IF AND based on an input + or -

Elizabeth Aird

I can get this to work and in my head it should :)

I want an "In Spec" IF… the Stage 1 Temp Verification is less than or equal to S1 Temp minus 5 AND Stage 1 Temp Verification is great than or equal to S1 Temp plus 5.

=If([Stage 1 Temp Verification]@row) <=([S1: Temp]@row + 5), ([Stage 1 Temp Verification]@row) >= ([S1: Temp]@row - 5), "In Spec", "Out of Spec"))

Jason Hamman

You need an OR statement. The formula you wrote is interpreted as this:

IF Stage1 Temp Verification <= S1: Temp +5

THEN Stage1 Temp Verification >= S1: Temp -5

Both are logic checks, which is why it returns "unparseable value."

Try this instead:

=If(OR([Stage 1 Temp Verification]@row) <=([S1: Temp]@row + 5), ([Stage 1 Temp Verification]@row) >= ([S1: Temp]@row - 5)), "In Spec", "Out of Spec"))

Jason Hamman

You need an OR statement. The formula you wrote is interpreted as this:

IF Stage1 Temp Verification <= S1: Temp +5

THEN Stage1 Temp Verification >= S1: Temp -5

Both are logic checks, which is why it returns "unparseable value."

Try this instead:

=If(OR([Stage 1 Temp Verification]@row) <=([S1: Temp]@row + 5), ([Stage 1 Temp Verification]@row) >= ([S1: Temp]@row - 5)), "In Spec", "Out of Spec"))

Elizabeth Aird

Getting an unparseable in return.. looks like too many parenthesis maybe?

Jason Hamman

https://community.smartsheet.com/discussion/comment/434695#Comment_434695

This cleans up some extraneous parens:

=If(OR([Stage 1 Temp Verification]@row <= ([S1: Temp]@row + 5), [Stage 1 Temp Verification]@row >= ([S1: Temp]@row - 5)), "In Spec", "Out of Spec")