Commisison Calculation

[elew69811]

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

 

[barry houdini]

Assuming the "sales" amount is in A1 then you can use this formula to get the total commission

=SUMPRODUCT(--(A1>{0,11000,14000}),A1-{0,11000,14000},{4,2,2})%

This is based on the method shown here

 

[elew69811]

Thanks very much!