Karkey : How do I use formulas for a single cell instead of an entire column?Hii,
Mukesh Karkey here ,I'm new to JMP and used to working in Excel. How can I apply a formula to only a single cell instead of the entire column? I need to calculate a value for just one row in my data table without affecting the others.
Regards,
Mukesh Karkey
WindowsRe: Karkey : How do I use formulas for a single cell instead of an entire column?JMP isn't a spreadsheet so you cannot really perform this type of calculations. You can calculate the values to new column and just take those values you are interested in.
Re: Karkey : How do I use formulas for a single cell instead of an entire column?Hey @mukeshkakkey ,
If you really wanted to brute force it, you could use an if statement that would say for a given row return a formula else return the raw data from another column for the rest of the rows.
From the Big class data set:
Re: Karkey : How do I use formulas for a single cell instead of an entire column? If you only need a single value, you could also look into using a table variable. Depending on your use of the data, this might be appropriate for your situation. Another option to consider and gives you more insights and advances your knowledge of JMP!
Re: Karkey : How do I use formulas for a single cell instead of an entire column?
JSL scripts can be used to specify cell calculations
Re: Karkey : How do I use formulas for a single cell instead of an entire column?To build on what @CoverMarmoset89 mentioned, you can refer to a single cell in a formula using brackets, as shown below. As @Dan_Obermiller mentioned, table variables are likely a better approach, though.
