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

Author Message
bartluff
Newbie

Joined: 11 Jan 2011
Posts: 4

 Posted: Tue Jan 11, 2011 6:12 am    Post subject: [Solved] Need formula for scaled commission I need a formula to calculated a scaled commission: (40% of the first \$200 or less) + (25% of the amount over \$200 up to \$500) + (20% of the amount over \$500). Thank you. [size=9]Tagged as solved - floris v[/size]
floris_v
Moderator

Joined: 12 Jul 2007
Posts: 4604
Location: Netherlands

 Posted: Tue Jan 11, 2011 6:37 am    Post subject: Something like =IF(A1<200;0.4*A1;IF(A1<500;80+(A1-200)/4;155+(A1-500)/5)) If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar._________________LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista Join the Official community forum - in several languages, including Nederlandstalig forum
bartluff
Newbie

Joined: 11 Jan 2011
Posts: 4

Posted: Tue Jan 11, 2011 2:11 pm    Post subject: Re: Need formula for scaled commission SOLVED

 bartluff wrote: I need a formula to calculated a scaled commission: (40% of the first \$200 or less) + (25% of the amount over \$200 up to \$500) + (20% of the amount over \$500). Thank you.

Works like a charm. Thank you so much. Bart
 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