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 €œundefined€� when €œ?€� on any column of A, B, & C
-To show €œpass€� when only €œb€�, or €œc€� or €œe€� (not €œa€� or €œx€� or €œ?€�) on A, B
& C columns.

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

Kevin, Dana and Dave thank you for your help. Ive put more conditions,
hopefully theres a way to come up with a formula.

--
Aline Yiu