MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
commission
Search

How Do I Calculate Total Commission On a Sliding Percentage Scale?

Monday January 11, 2021. 07:27 PM , from MacMost
Trying to create a formula to calculate commission in a month.
If I make a company £18,000 in a month commission would be £2599.65.
Commission banding is
0-5,000 – 10%
5001-15,000 – 15%
15,001 or more – 20%
How would you create a formula to calculate the commission due?
—–
Alex
https://macmost.com/forum-how-do-i-calculate-total-commission-on-a-sliding-percentage-scale.html
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Apr, Sat 27 - 06:26 CEST