Checking the results of a number of IF formula

[Stu]

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(G21>E21,G21<F21),"Pass","Fail")
4 121.77 152.68 136.2 =IF(AND(G22>E22,G22<F22),"Pass","Fail")
5 268.2 332.75 301.9 =IF(AND(G23>E23,G23<F23),"Pass","Fail")
6 242.43 300.19 271.69 =IF(AND(G24>E24,G24<F24),"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

 

[Steve Dunn]

=if(isna(match("Fail",D36,0)),"Pass","Fail")

 

[Ron Rosenfeld]

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(G21>E21,G21<F21),"Pass","Fail")
4 121.77 152.68 136.2 =IF(AND(G22>E22,G22<F22),"Pass","Fail")
5 268.2 332.75 301.9 =IF(AND(G23>E23,G23<F23),"Pass","Fail")
6 242.43 300.19 271.69 =IF(AND(G24>E24,G24<F24),"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

 

[adam6b]

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:G5>E2:E5),--(G2:G5<F2:F5))=COUNT(G2:G5),"All "
&COUNT(G2:G5)&"
Passed",COUNT(G2:G5)-SUMPRODUCT(--(G2:G5>E2:E5),--(G2:G5<F2:F5)) & " Failed")

 

[Teethless mama]

=IF(COUNTIF(D36,"Fail"),"Fail","Pass")