Formula reflecting mutliple results

[Guest]

What formula to write on D column:

To show “fail†when there’s an “a†or “x†on any column of A, B & C.
To show “pass†when only “bâ€, or “c†or “e†(not a or x) on A, B & C columns.

A B C D
a a x fail
c b x fail
e c b pass
e e a fail
c b c pass
c b b pass

 

[Guest]

This formula should do the trick:

=IF(OR(A9="a",B9="a",C9="a",A9="x",B9="x",C9="x"),"fail","Pass")

 

[Guest]

P.S. You'll have to replace the row number 9 with the relevant row for your
layout. I just happened to insert the formula in row 9

 

[Dana DeLouis]

This array formula only checks for "a" or "x".

=IF(OR((A1:C1="a"),(A1:C1="x")),"Fail","Pass")

Ctrl+Shift+Enter

 

[Dave Peterson]

If you can always just have Pass/Fail (only depend on a's and x's):

=IF(SUM(COUNTIF(A1:C1,{"a","x"}))>0,"Fail","Pass")

If you can have other options besides a,x, b,c,e:
=IF(SUM(COUNTIF(A3:C3,{"a","x"}))>0,"Fail",
IF(SUM(COUNTIF(A3:C3,{"b","c","e"}))>0,"Pass","Undefined"))

If you're going to compose in MSWord, you should turn those smart quotes off.
It really clutters up your message's intent.

Maybe composing in NotePad would be better????