Formula reflecting mutliple results--continued
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)
"Aline Yiu" wrote in message
...
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.
--
Aline Yiu
|