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","Und efined"))

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????

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

--

Dave Peterson