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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!