# tiered commission

1. ### Calculating Tiered Commission Structure based on Rolling Annual Contribution

Hello! I'm having trouble creating a spreadsheet that will calculate correctly. Our commission structure is set up as follows: We take 10% of the total commission received per sale (our "FF"), 90% goes back to the employee. However, once the employee has contributed \$15k, our FF goes down to...
2. ### Calculating Commission Structure

Hello I am trying to create an excel table to calculate a commission structure. Here is the structure that I am working with: <colgroup><col span="3"><col></colgroup><tbody> £0k to £9k 0% £0.00 £9k - £29999 10% £2,100.00 £30k - £44999 15% £2,250.00 £45k - £59999 20% £3,000.00 £60k+...
3. ### Calculating commissions with tiers, by month, AND across multiple people.

My question is related to calculating sales commissions. Here's my problem: determining a commission rate is based on what has been closed in a territory, but calculating the actual commission earned is based off what a person himself closed. I know how to do this with a ton of nested if...
4. ### Urgent Help! Calculating Tiered Commission...Please!

Hi all I am trying to work out a formula for my below commission structure; £0.00 - £5,000 generated = 0% commission £5,000 - £10,000 = 15% commission £10,000 - £15,000 = 17.5% commission £15,000 - £20,000 = 20% commission £20,000 - £25,000 = 22.5% commission £25,000 + = 25% commission (so...
5. ### Calculating Tiered Commission with an IF statement

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I need a formula to help calculate the commission for my team at work. We are collectors and take credit card payments to clear up delinquency. Here is how the tiers work:<o:p></o:p> <o:p>...

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