=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