[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Ratso
General User

Joined: 14 Jan 2006
Posts: 16

 Posted: Mon Jun 04, 2012 1:42 am    Post subject: (SOLVED) Multiple Conditions for If formula trouble. 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 appreciatedLast edited by Ratso on Mon Jun 04, 2012 9:21 pm; edited 1 time in total
scsisys
OOo Advocate

Joined: 17 Dec 2009
Posts: 200

 Posted: Mon Jun 04, 2012 4:02 am    Post subject: 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

 Posted: Mon Jun 04, 2012 8:22 pm    Post subject: 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 Advocate

Joined: 17 Dec 2009
Posts: 200

 Posted: Mon Jun 04, 2012 9:08 pm    Post subject: 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

 Posted: Mon Jun 04, 2012 9:18 pm    Post subject: 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 Advocate

Joined: 17 Dec 2009
Posts: 200

 Posted: Tue Jun 05, 2012 4:42 am    Post subject: 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group