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

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

mukeshkakkey — Tue, 09 Sep 2025 05:09:42 GMT

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

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

jthi — Tue, 09 Sep 2025 05:39:35 GMT

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?

shampton82 — Tue, 09 Sep 2025 17:22:46 GMT

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?

Dan_Obermiller — Tue, 09 Sep 2025 23:11:57 GMT

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?

lwencx — Wed, 10 Sep 2025 08:45:09 GMT

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

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

Jed_Campbell — Wed, 10 Sep 2025 19:35:30 GMT

To build on what @lwencx 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.