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

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

"Stu" <(E-Mail Removed)> wrote in message
news:FB810DF9-84EA-4C2B-8416-(E-Mail Removed)...
> 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

On Fri, 9 Apr 2010 03:26:01 -0700, Stu <(E-Mail Removed)> 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(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

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")

"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(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

=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(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