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!