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