HELP with IF formula

  • Im trying to create IF formula, from A1 to M1.
    A1 to M1 could have a value of : "N/A", "PASSED"or any value
    now what im trying to do is to have a formula that will show O1, If the user gets all passed fields, Or at lease one failed.
    Formula logic should look like:

    IF A1: M1 = PASSED or N/A then O1 = Passed
    IF A1:M1= N/A or Any value then O1 = Failed

    Passed if A1:M1 is just showing N/A or Passed, other than that is should show FAILED.

    Thanks in advance!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!