This formula should do the trick:

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


"Aline Yiu" wrote:

What formula to write on D column:

To show €œfail€� when theres 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

--
Aline Yiu