If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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,G21F21),"Pass","Fail") 4 121.77 152.68 136.2 =IF(AND(G22E22,G22F22),"Pass","Fail") 5 268.2 332.75 301.9 =IF(AND(G23E23,G23F23),"Pass","Fail") 6 242.43 300.19 271.69 =IF(AND(G24E24,G24F24),"Pass","Fail") I have tried the following IF formula =IF(D36="Pass","Pass","Fail") but it can't seem to check text or formulas. Any suggestions on other formula to use?? Thanks Stu |
#2
|
|||
|
|||
Checking the results of a number of IF formula
=if(isna(match("Fail",D36,0)),"Pass","Fail")
"Stu" wrote in message ... 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,G21F21),"Pass","Fail") 4 121.77 152.68 136.2 =IF(AND(G22E22,G22F22),"Pass","Fail") 5 268.2 332.75 301.9 =IF(AND(G23E23,G23F23),"Pass","Fail") 6 242.43 300.19 271.69 =IF(AND(G24E24,G24F24),"Pass","Fail") I have tried the following IF formula =IF(D36="Pass","Pass","Fail") but it can't seem to check text or formulas. Any suggestions on other formula to use?? Thanks Stu |
#3
|
|||
|
|||
Checking the results of a number of IF formula
On Fri, 9 Apr 2010 03:26:01 -0700, Stu wrote:
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,G21F21),"Pass","Fail") 4 121.77 152.68 136.2 =IF(AND(G22E22,G22F22),"Pass","Fail") 5 268.2 332.75 301.9 =IF(AND(G23E23,G23F23),"Pass","Fail") 6 242.43 300.19 271.69 =IF(AND(G24E24,G24F24),"Pass","Fail") I have tried the following IF formula =IF(D36="Pass","Pass","Fail") but it can't seem to check text or formulas. Any suggestions on other formula to use?? Thanks Stu You want to see if there are no "Fails" in the list? try (not tested): =if(countif(d3:d6,"Fail")=0, "All Pass", "Not All Pass") --ron |
#4
|
|||
|
|||
Checking the results of a number of IF formula
Stu,
This one won't be dependent on your column D. It will run the test independently, but should get the same result... Also, it will count the number of tests and tell you how many failed or the total number passed. pretty fun. =IF(SUMPRODUCT(--(G2:G5E2:E5),--(G2:G5F2:F5))=COUNT(G2:G5),"All " &COUNT(G2:G5)&" Passed",COUNT(G2:G5)-SUMPRODUCT(--(G2:G5E2:E5),--(G2:G5F2:F5)) & " Failed") "Stu" wrote: 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,G21F21),"Pass","Fail") 4 121.77 152.68 136.2 =IF(AND(G22E22,G22F22),"Pass","Fail") 5 268.2 332.75 301.9 =IF(AND(G23E23,G23F23),"Pass","Fail") 6 242.43 300.19 271.69 =IF(AND(G24E24,G24F24),"Pass","Fail") I have tried the following IF formula =IF(D36="Pass","Pass","Fail") but it can't seem to check text or formulas. Any suggestions on other formula to use?? Thanks Stu |
#5
|
|||
|
|||
Checking the results of a number of IF formula
=IF(COUNTIF(D36,"Fail"),"Fail","Pass")
"Stu" wrote: 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,G21F21),"Pass","Fail") 4 121.77 152.68 136.2 =IF(AND(G22E22,G22F22),"Pass","Fail") 5 268.2 332.75 301.9 =IF(AND(G23E23,G23F23),"Pass","Fail") 6 242.43 300.19 271.69 =IF(AND(G24E24,G24F24),"Pass","Fail") I have tried the following IF formula =IF(D36="Pass","Pass","Fail") but it can't seem to check text or formulas. Any suggestions on other formula to use?? Thanks Stu |
Thread Tools | |
Display Modes | |
|
|