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 thanks

Not that I know of but I can easily write you one. Let me know if you
need it.

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)

"andyhofer" wrote:


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 thanks


--
andyhofer