Karkey : How do I use formulas for a single cell instead of an entire column?

[#1]

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

[#2]

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.

[#3]

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:

[#4]

 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!

[#5]

可以用JSL脚本，可用于指定单元格计算

[#6]

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.