54476_en-US

liliconcom

Translating Excel If/and/match to JMP formula

advising on translating Excel If/and/match to JMP formula

=IF(AND(B2=C2, B2=D2), "Yes", "No")

 

If Match formula from excel to JMP

Re: Translating Excel If/and/match to JMP formulaThanks, it works prefectly
Re: Translating Excel If/and/match to JMP formula

Here are 2 different formulas that work

If( :Run1 == :Run2 & :Run1 == :Run3,
 "Yes",
 "No"
);
// Or
If( And( :Run1 == :Run2, :Run1 == :Run3 ),
 "Yes",
 "No"
);

I suggest that you read the chapter on the Formula Editor in the Using JMP guide

     Help==>Books==>Using JMP