How to specify a data cell into a column formula?

[#1]

I am having trouble writing a simple column formula as I do not know the syntax to specify a specific datapoint/cell within the formula itself. In the past, I have manually entered the value, but am trying to streamline the process using action recorder/scripts.

I need to subtract column #1row #5 from every value in column #1 and put the resulting value into column#2. For example, in Excel, the formula would be =A1-$A$5. But I don't know how to specify a specific column/row in JMP formulas. I'm using JMP Pro 16 on windows. 

[#2 · Accepted solution]

You use subscripts to reference a specific row.

 

[#3]

Thank you!