I am trying to work out a formula to calculate commissions. It is a little complicated and is as follows.
If they make between 1-11,000 it is 4%
Anything between 11,001 and 14,000 is 6% plus the 4% of the amount they earned on the 1-11,000
Anything over 14,001 is 8% plus what they have earned on the other 2 thresholds. Is this possible?
Thanks
If they make between 1-11,000 it is 4%
Anything between 11,001 and 14,000 is 6% plus the 4% of the amount they earned on the 1-11,000
Anything over 14,001 is 8% plus what they have earned on the other 2 thresholds. Is this possible?
Thanks