Formula reflecting mutliple results
 

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

Formula reflecting mutliple results
 

This formula should do the trick:

=IF(OR(A9="a",B9="a",C9="a",A9="x",B9="x",C9="x"), "fail","Pass")
--
Kevin Backmann


"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

Formula reflecting mutliple results
 

P.S. You'll have to replace the row number 9 with the relevant row for your
layout. I just happened to insert the formula in row 9
--
Kevin Backmann


"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

Formula reflecting mutliple results
 

This array formula only checks for "a" or "x".

=IF(OR((A1:C1="a"),(A1:C1="x")),"Fail","Pass")

Ctrl+Shift+Enter
--
Dana DeLouis


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

Formula reflecting mutliple results
 

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