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?
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?
Hi,
Maybe you can use somthing like this:
=IF((E3="Y")+(H3>=10)+(I3="Win")>=2,"Pass","Fail")
Regards,
Bondi
Try this formula:
=IF(OR(AND(E3="Y",H3>=10),AND(E3="Y",I3="Win"),AND(H3>=10,I3="Win")),"PASS","")
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
>
>
=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
>
>
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
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks