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

=if(isna(match("Fail",D3:D6,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,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

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,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

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

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

=IF(COUNTIF(D3:D6,"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,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