tiered commission rate

  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+...
    • bobitici
    • Thread
    • commision calculation commission formula tier billing tiered commission tiered commission rate
    • Replies: 3
    • Forum: Excel Questions
  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. B

    Tiered Commission Rates

    I know this has been discussed before but I can't apply the solutions to my example. We have several different commission bands and each of those bands has a tiered commission rate e.g. Band1, First 0-10K = 1.95%, then from 10k to 20K = .8%, then all the rest is .5%. So what I am looking for...

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
Back
Top