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

  • Garrett Henke
    Garrett Henke ✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!