I have a cell (G9) that I want to populate as "FAIL" if cells K2 through K6 return the word "FAIL", "PASS" if not. And "FAIL" if cells N4 through N8 have a less than more than factor that gives a pass fail in G9.
This part works:
=IF(COUNTIF(K2:K6,"FAIL"),"FAIL","PASS")
This also works:
=IF(AND(N4>0,N4<33),"FAIL","PASS")
However, if I add anything to it, it fails.
=IF(SUM(N4>0,N4<33),"FAIL",(N5>0,N5<33),"FAIL",(N6>0,N6<32),"FAIL",(N7>0,N7<30),"FAIL",(N8>0,N8<20),"FAIL","PASS"))
N4 and N5 have the same <>, N6 is <32, N7 is <30, N8 is <20.
Please help, I have spent a couple of hours on this and I know my boss is about to get irritated with me on long this is taking me.
Bookmarks