Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN THIS WORK?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN THIS WORK?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |