AND/OR statements in Formula Editor

[#1]

Hi All,

I was hoping someone could help me with a formula containing AND/OR statements.  I have written a formula in "Column 5" based on the results of 3 other columns: Run F, Run M, and Run S.  The portions of the formula that only contain IF/THEN statements produce the desired results.  However, the portions of the formula that also contain AND/OR statements do not work (non-working portions of the formula are circled in RED in the attached screen shot).  The JMP file is also attached below.  Can anyone please help on what I am doing wrong?

Thank you!

Erica

[#2 · Accepted solution]

Try this form and see if the logic works correctly

If(
	:Run F == 1 | :Run M == 1, "Leave",
	:Run F == 2, "Keep",
	:Run F == 3, "Upscale",
	(:Run F == 4 | :Run F == 5) & (:Run S == 1 | :Run S == 2), "Fix",
	(:Run F == 4 | :Run F == 5) & (:Run S == 3 | :Run S == 4), "Encode",
	:Run M == 2, "Upscale",
	:Run M == 3 & (:Run S == 1 | :Run S == 2), "Fix",
	:Run M == 3 & (:Run S == 3 | :Run S == 4), "Encode"
)

[#3]

That works perfectly!!  Thank you so much, Txnelson!!  I greatly appreciate your help!!