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
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!