Checking if 2 of 3 conditions are met...
 

I'm trying to figure out an =IF to check if 2 of 3 conditions are met.
The conditions are as follows

E="Y"
H3=10
I3="Win"

What I'm trying to do is set the value in a cell to "Pass" if ANY 2 (or
all 3) of the conditions are met. Any ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=556935

Checking if 2 of 3 conditions are met...
 

Hi,

Maybe you can use somthing like this:

=IF((E3="Y")+(H3=10)+(I3="Win")=2,"Pass","Fail")

Regards,
Bondi

Checking if 2 of 3 conditions are met...
 

Try this formula:

=IF(OR(AND(E3="Y",H3=10),AND(E3="Y",I3="Win"),AND (H3=10,I3="Win")),"PASS","")

Checking if 2 of 3 conditions are met...
 

Put this into your target cell

=IF(OR(AND(E3="Y",H3=10),AND(E3="Y",I3="Win"),AND (H3=10,I3="Win")),"Pass","Fail")

--
HTH

JonR


"guilbj2" wrote:


I'm trying to figure out an =IF to check if 2 of 3 conditions are met.
The conditions are as follows

E="Y"
H3=10
I3="Win"

What I'm trying to do is set the value in a cell to "Pass" if ANY 2 (or
all 3) of the conditions are met. Any ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=556935

Checking if 2 of 3 conditions are met...
 

=IF(OR(AND(E3="y",OR(H3=10,I3="win")),AND(H3=10,I3 ="win")),"Pass","Fail")

Vaya con Dios,
Chuck, CABGx3



"guilbj2" wrote:


I'm trying to figure out an =IF to check if 2 of 3 conditions are met.
The conditions are as follows

E="Y"
H3=10
I3="Win"

What I'm trying to do is set the value in a cell to "Pass" if ANY 2 (or
all 3) of the conditions are met. Any ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=556935

Checking if 2 of 3 conditions are met...
 

Opps.........forgot the symbol...........

=IF(OR(AND(E3="y",OR(H3=10,I3="win")),AND(H3=10, I3="win")),"Pass","Fail")

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

=IF(OR(AND(E3="y",OR(H3=10,I3="win")),AND(H3=10,I3 ="win")),"Pass","Fail")

Vaya con Dios,
Chuck, CABGx3



"guilbj2" wrote:


I'm trying to figure out an =IF to check if 2 of 3 conditions are met.
The conditions are as follows

E="Y"
H3=10
I3="Win"

What I'm trying to do is set the value in a cell to "Pass" if ANY 2 (or
all 3) of the conditions are met. Any ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=556935