If a value is within tolerance, the formula should return “OK”.
If the value is out of tolerance, the formula should return “Fail”.
When the logical test returns FALSE, IF returns “Fail”.
These messages can be customized as needed.
More than one condition can be tested by nesting IF functions.
The IF…
ABS Function
The Excel ABS function returns the absolute value of a number.
ABS converts negative numbers to positive numbers, and positive numbers are unaffected.
