Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/07/If-Value-is-Within-Tolerance.xlsx

In this video I demonstrate how to calculate whether a result has met a benchmark within a tolerance level. The functions used are ABS and IF.

I also demonstrate how to conditionally format a value if falls outside a tolerance level - plus or minus.
------------------------