Using rounded data in calculations

[#1]

Appears to be such a simple thing but I have not been able to figure out how to do it - I have a calculations in Column B derived from values in Column A, and in in Column C I want to calculate the natural log of these Column B results (using values to 2 decimal places in scientific or 3 sig figs). I can get JMP to display to what I want but I cannot get the Column C calculations to calculate using rounded/sigfig data.

I am sure there must be a simple way to do this (and I want to avoid copy and pasting from Excel (where it's incredibly simple)) but I have no idea and can't find anything through Google searches.

[#2 · Accepted solution]

I have figured it out and so will answer my own question, used the following formula:

Ln (Round (As Column ("B"), -4))

[#3]

it looks like your problem may be related to referencing column names.

The column named "B" can be referenced as :B and also as "B"n

Log (Round(:B,-4)). or log (Round("B"n,-4) would work