jeudi 23 janvier 2020

3 criteria for an if statement excel

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