Checking the results of a number of IF formula

  • Thread starter Thread starter Stu
  • Start date Start date
S

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(D3:D6="Pass","Pass","Fail")

but it can't seem to check text or formulas. Any suggestions on other
formula to use??
Thanks
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(D3:D6="Pass","Pass","Fail")

but it can't seem to check text or formulas. Any suggestions on other
formula to use??
Thanks
Stu
Click to expand...

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