topic Re: Using rounded data in calculations in Discussions

Using rounded data in calculations

cronshad — Sat, 10 Jun 2023 23:50:03 GMT

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.

Re: Using rounded data in calculations

cronshad — Wed, 22 Jun 2022 00:19:15 GMT

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

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

Re: Using rounded data in calculations

Byron_JMP — Wed, 22 Jun 2022 13:56:04 GMT

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