Formula reflecting mutliple results--continued

[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 “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. I’ve put more conditions,
hopefully there’s a way to come up with a formula.

 

[Ron Coderre]

With your posted data in A1:C9

D1:
=CHOOSE(MAX((COUNTIF(A1:C1,{"A","X","~?","B","C","E"})>0)*{3,3,2,1,1,1}+1),"No
Data","Pass","Undefined","Fail")
Copy that formula down through D9.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

 

[Guest]

Hi Ron,

THANK YOU SO MUCH... It works like a charm. You are amazing wondering how
you come up somthing like this.

Have a great day,
Aline xxx

 

[Ron Coderre]

Thanks for the kind words.....(That's one of my favorite "tricks")

--------------------------
Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)