(SOLVED) Multiple Conditions for If formula trouble.

Ratso · General User Joined: 14 Jan 2006 Posts: 16

For years i have been using a formula in a spreadsheet with no dramas.
=IF((L20+M20/2)>3;"WIN";"-")
which gives me a "WIN" in Cell N20 if I have 3 or more in L20 & 1 or 2 in M20 or if less "-".
Now I have to add a further condition as well.
If L20 is 1 or more & M20 is 2 I also need N20 to give me a "WIN" or if less "-".
I have tried many different formulas for this but can't seem to crack it.
Any help would be appreciated

scsisys · OOo Enthusiast Joined: 17 Dec 2009 Posts: 164

Ratso....

Try this ; =IF(AND(L20>=1;M20=2);"Win";"-")

scsisys
_________________
OO 3.2.1
Win XP /SP3

Ratso · General User Joined: 14 Jan 2006 Posts: 16

Thanks for the reply.
Your formula works for the new condition but not the old one.
I need both to be able to work.
I tried this formula but all I get in N20 is TRUE.
=IF(($L20+$M20/2)>3;"WIN";"-")=IF(AND(L20>=1;M20=2);"Win";"-")
Still Stumped.
Ratso.

scsisys · OOo Enthusiast Joined: 17 Dec 2009 Posts: 164

If I'm understanding your requirements, this appears to work.....

=IF(OR(AND(L20>=1;M20=2);((L20+M20/2)>3));"win";"-")

scsisys
_________________
OO 3.2.1
Win XP /SP3

Ratso · General User Joined: 14 Jan 2006 Posts: 16

Thanks very much scsisys.
I Tried your formula, =IF(OR(AND(L20>=1;M20=2);((L20+M20/2)>3));"win";"-")
in my spreadsheet and it does work as iI wanted it to.
I never would have been able to figure out that string by myself.
Thanks once again.
Ratso

scsisys · OOo Enthusiast Joined: 17 Dec 2009 Posts: 164

You're quite welcome. Have to apologize as I interpreted your request as meaning a formula to be used in a second, independent, cell and not as an addition to the existing
formula.

Have a good day....

scsisys
_________________
OO 3.2.1
Win XP /SP3