How can I add a third set of criteria to an if statement. There are 3 vaules: Pass, Fail or ND. My code will read the cell and assign it to a pass or fail.
=IF(OR(A1 = "Fail",A2 = "Fail", A3 = "Fail"), "Fail", "Pass")
However if the cell contains an ND how can record this? I was thinking something like below, but that doesn’t work.
=IF(OR(A1 = "Fail",A2 = "Fail", A3 = "Fail", A4 = “ND”), "Fail", "Pass", “ND”)
Aucun commentaire:
Enregistrer un commentaire