I was using the following formula:
=IF(A1>(b1*1.01),"NO","YES")
This works fine if the variance is greater than 1% on the plus side (for tolerance levels), however, if the variance is greater than 1% on the negative side, my formula doesn't work.
Any suggestions on how to edit?
Bookmarks