# Commisison Calculation

#### elew69811

##### Board Regular
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

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### barry houdini

##### MrExcel MVP
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

##### Board Regular
Thanks very much!

Replies
5
Views
143
Replies
9
Views
280
Replies
0
Views
288
Replies
5
Views
231
Replies
11
Views
337

1,195,600
Messages
6,010,650
Members
441,558
Latest member
lambierules

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back