Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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","") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |