tiered commission

  1. B

    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+...
  2. E

    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...
  3. L

    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...
  4. P

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

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top