IF Formula Help
Good afternoon,
I need some help with a formula please. I have the following cells:
Recorded Dimension
Nominal
Upper Limit
Lower Limit
I would like for a Pass/Fail condition in another cell so that if the Recorded Dimension is above the Upper Limit or below the Lower Limit then it will return as a "Fail", if it falls between the upper and lower limit however, it will return as "Pass".
I appreciate any help you can give with this.
Thank you.
Answers

The formula you will need is =IF(AND([Recorded Dimension]@row >= [Lower Limit]@row, [Recorded Dimension]@row <= [Upper Limit]@row), "Pass", "Fail")
In the formula above it will pass if the recorded dimension is greater than or equal to the lower limit as well as less than or equal to the upper limit. You can remove the = after the less than / greater than in the formula if the values must fall within the range and not equal to either limit.
=IF(AND([Recorded Dimension]@row > [Lower Limit]@row, [Recorded Dimension]@row < [Upper Limit]@row), "Pass", "Fail")
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!