lundi 20 mars 2017

Look for a word in a set of cells

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