topic Using formula in Discussions

Using formula

OmegaKoala673 — Wed, 22 Jun 2022 03:17:18 GMT

Hello everyone, i am wondering if there is anyone that can help with a formula problem. I would like to compare two different columns and result the values in a third column but i cannot find a versus formula on jmp. Any ideas or suggestions are highly appreciated. Thank you!

Re: Using formula

jthi — Wed, 22 Jun 2022 04:24:44 GMT

What type of comparison do you need?

Re: Using formula

Byron_JMP — Wed, 22 Jun 2022 13:52:00 GMT

It sounds like you need a formula that does something like Subtract Col1 from Col2 and then check to see if it equals Col3.

The formula would sound like, "If Column1 minus Column2 equals Column3, then put 'Yes' in this column, and if not, then put 'no' in this column."

The formula would look like this

if (:Column 1-:Column 2 == :Column 3, "Yes", "No")