IF AND based on an input + or 
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"))
Best Answer

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

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

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

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")
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!