ExcelBanter - CAN THIS WORK?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CAN THIS WORK? (https://www.excelbanter.com/excel-discussion-misc-queries/81173-can-work.html)

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

Hi

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

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

Hope this helps.
Andy.

"TUGGERBEARS" wrote in message
...
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