Formulae for Tolerence

A

andyhofer

Is there a function that can be used to identify tolerences of answers.

ie. if the answer is within 5% of a specified number then this is OK
It needs to work on both positive and negative numbers

many thank
 
J

JMB

This seems to work. Where D4 is the answer and E4 is the specified number.
You can change the ROUND functions to however many decimals of precision
you're looking for.

=ROUND(ABS(E4-D4),5)<ROUND(ABS(5%*E4),5)
 
Top