logical function problem

Originally Posted by meddington

Ok, got another one.

I'm wondering how to alter the code to include a third possiblity..."pass", "fail" or "Data missing". An array formula?

Hi
Please make it more clear that when you want to return each of three possibilties.
1) return "Fail" if even a single fail is found
2) return "Pass" if all are pass
3) return "Data missing" when???