| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking the results of a number of IF formula
Hi
I am trying to verify that all the tests have passed in the Table below and show an over all pass. 1 B B C D 2 Lower Upper Measured Pass/Fail 3 309.6 379.5 344 =IF(AND(G21E21,G21<F21),"Pass","Fail") 4 121.77 152.68 136.2 =IF(AND(G22E22,G22<F22),"Pass","Fail") 5 268.2 332.75 301.9 =IF(AND(G23E23,G23<F23),"Pass","Fail") 6 242.43 300.19 271.69 =IF(AND(G24E24,G24<F24),"Pass","Fail") I have tried the following IF formula =IF(D3:D6="Pass","Pass","Fail") but it can't seem to check text or formulas. Any suggestions on other formula to use?? Thanks Stu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking a date/number between two others | Excel Discussion (Misc queries) | |||
| Returning zero if the results of a formula is a negative number? | Excel Discussion (Misc queries) | |||
| DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS | Excel Discussion (Misc queries) | |||
| number checking | Excel Discussion (Misc queries) | |||
| number checking | Excel Discussion (Misc queries) | |||
Threaded Mode
