User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
View Translated Thread
OmegaKoala673
OmegaKoala673
Level I

Using formula

Jun 21, 2022 11:17 PM (1085 views)

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!

0 Kudos
2 REPLIES 2
jthi
Super User jthi
Super User

Re: Using formula

Jun 22, 2022 12:24 AM (1072 views)  |  Posted in reply to message from OmegaKoala673 06-21-2022

What type of comparison do you need?

-Jarmo
Byron_JMP
Staff Byron_JMP
Staff

Re: Using formula

Created: Jun 22, 2022 09:51 AM  |  Last Modified: Jun 22, 2022 6:52 AM (1058 views)  |  Posted in reply to message from OmegaKoala673 06-21-2022

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")

JMP Systems Engineer, Health and Life Sciences (Pharma)
0 Kudos

Recommended Articles