I need a formula for a sliding scale commission. I have figured it out in separate steps but not in one nice neat formula. The sliding scale is 40% on the 1st $100, 30% on the 2nd $100, 25% on the 3rd $100, 20% on the 4th $100, and 15% on anything over $400. Example: If something sold for $580 the commission would be: $40 of the 1st $100, $30 of the second $100, $25 of the 3rd $100, $20 of the 4th $100, and $27 of the remaining $180 after $400.
What I would like is:
1st cell= what the sale was for
2nd cell=what the commission is
3rd cell=what the remainder is
Please, please, please help me.
Thanks
Daniel
Bookmarks