conditional formula

[Qaspec]

I have 3 cells that will return a value of "yes" or "no". In another cell if
any of the other 3 cells has a no I would like it to say "fail", if all 3 are
"yes" I'd like it to say "pass".

A1 yes
B1 no
C1 yes
E2 fail

a1 yes
b1 yes
c1 yes
e2 pass

 

[JE McGimpsey]

One way:

E2: =IF(COUNTIF(A1:C1,"yes")=3,"pass","fail")

 

[Guest]

=IF(AND(A1="yes",B1="yes",C1="yes"),"pass","fail")