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

Author Message
phil1986
Newbie

Joined: 31 Dec 2008
Posts: 1
Location: Bournemouth, England

 Posted: Wed Dec 31, 2008 9:42 am    Post subject: Multiple IF conditions Hello, Quite a simple question I think, but I'm a newly converted OO user from Excel. I tried to search in the forum, but couldn't find anything. In Calc, I need a formula in cell G5 that does the following: IF E5 <= 0, return £0 IF E5 > 0 but <= 500, return £50 IF E5 > 500 but <= 1000, return £100 IF E5 > 1000, return £150 Thanks if you can help me out. And have a HAPPY NEW YEAR!!!
David
Super User

Joined: 24 Oct 2003
Posts: 5668

 Posted: Wed Dec 31, 2008 11:32 am    Post subject: If statements are parsed from left to right until a truth is found: =IF(E5<=0;0;IF(E5<=500;50;IF(E5<=1000;100;150))) Happy New Year to you also. David.
 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