CAN THIS WORK?

T

TUGGERBEARS

I HAVE A COLUMN OF NUMBER EXAMPLE: .03199 AND NEED TO FIND OUT WHETHER THAT
IS WITHIN 15% OF A NUMBER IN THE NEXT COLUMN EX: .035
AND IF THAT CAN BE DONE CAN I HAVE A THIRD COLUMN BE AUTOMATICALLY CHANGED
TO PASS IF IT IS WITHIN THE 15% OR FAIL IF IT IS NOT.

THANK YOU IN ADVANCE
STEPH
 
G

Guest

Hi

You could do it in one cell like this:
=IF(OR(B2*1.15<A2,B2*0.85>A2),"fail","pass")

This is assuming your number (0.03199) is in A2 and your measure (.035) is
in B2

Hope this helps.
Andy.
 
Top