Checking if 2 of 3 conditions are met...

G

guilbj2

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?
 
B

Bondi

Hi,

Maybe you can use somthing like this:

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

Regards,
Bondi
 
E

Ed

Try this formula:

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

JonR

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

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning 1 of 4 values if conditions are met 4
conditional formatting for more than 3 conditions 3
conditional formatting 2
Sum Totals/Different Conditions 3
Date Formula with 2 conditions met needed 7
Excel 2010 Conditional Formatting 2
Slideshow with black border around it 0
Conditional Formatting - Row colour 4

Top