OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Multiple IF conditions

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
phil1986
Newbie
Newbie


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

PostPosted: Wed Dec 31, 2008 9:42 am    Post subject: Multiple IF conditions Reply with quote

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!!!
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed Dec 31, 2008 11:32 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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