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