| View previous topic :: View next topic |
| 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] |
|
| Back to top |
|
 |
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 |
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
|
