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

Author Message
hankyknot
Newbie

Joined: 14 Sep 2007
Posts: 1

 Posted: Fri Sep 14, 2007 3:58 am    Post subject: IF question I am trying to get a calculation that in plain english does the following IF D3 is less than 100 then the answer is 5, IF D3 is between 101 & 150 then the answer is 10, IF D3 is greater than 150 then the answer is D3 * .07 I can get a single true/false IF statement with no problem but including the 3rd factor is proving difficult. I have googled for an answer but cannot find one. Any ideas
willow
General User

Joined: 20 Oct 2005
Posts: 37
Location: Crowthorne, Berkshire, UK

 Posted: Fri Sep 14, 2007 4:06 am    Post subject: Nest the IF's If I understand your problem correctly you need to nest the "IF" tests. Start with the highest condition ( > 150 ) and if it passes that test get the result. If it fails then use another IF to do the second and third part. =IF(D3>150;D3*0.7;IF(D3>100;10;5))
Hagar Delest
Super User

Joined: 06 Feb 2006
Posts: 5167
Location: France

 Posted: Fri Sep 14, 2007 5:07 am    Post subject: I'd made a quick description about exactly the same issue here : [SOLVED] Help with IF statement. Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed._________________Now on the EN user community forum
 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