Choose Language Hide Translation Bar
Highlighted
Nithian
Level I

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 JMPIf Match formula from excel to JMP

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

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

jim's repeatable.PNG

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

     Help==>Books==>Using JMP

Jim

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

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

jim's repeatable.PNG

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

     Help==>Books==>Using JMP

Jim

View solution in original post

Highlighted
Nithian
Level I

Re: Translating Excel If/and/match to JMP formula

Thanks, it works prefectly
Article Labels

    There are no labels assigned to this post.