I am trying to create a cell that gives a pass/fail result based on the contents of D11:D15. If even one of the cells in that range have the value of "FAIL", I want the cell above (that the formula is going into) to read "FAILED". If they are all "PASS", I would like it to say "PASSED". Sounds simple enough, but I'm having issues
=IF((ISNUMBER(SEARCH("FAIL",D11:D15))),"FAILED","PASSED")
This formula is returning passed no matter what. Even if there are fails in the range. What am i missing here?
Thanks for your time!
Aucun commentaire:
Enregistrer un commentaire