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!