commissions

  1. B

    Tiered bonus structure

    Trying to setup a spreadsheet to do this but here's the grid below. Bonuses are ONLY given on the amount between the threshold. For instance, if you do 500K of commission and fee's, you get a bonus on tier 1 on 99,999 of production, then you also get a bonus on the 299,999 of production. You...
  2. G

    IF date statement

    Hello Experts I will like to see if anyone can help me simplify a formula that I just manage to getter bigger and bigger and I know it may be an easier way I have a file that we paid commissions and under the file there a date column so I create a formula to lookup that value and return the...
  3. rjbinney

    Pull Data from Multiple Worksheets

    I feel like I knew how to do this once, but I'll be ****ed if I can find a worksheet where I pulled it off. Essentially, I have a workbook where expenses are logged in monthly tabs (so May 2017 has a sheet listing each category and expense, June has its own, etc. etc.). Now I'd like to write a...
  4. S

    Tiered Commissions that pay difference back to dollar one.

    Hello. I need help with a tiered commission formula that would pay commissions back to dollar one as the rep reached new tiers. For instance, for sales up to $1,000,000 they get a 3.5% commission. Once they hit $1,000,001, the commissions are 6.00%, and they get paid on the first 1,000,000 an...
  5. C

    Sales commission

    Hi, Need formula to calculate sales commissions on incremental value. Thanks
    • chunu
    • Thread
    • calculate commission commissions incremental sales
    • Replies: 6
    • Forum: Excel Questions
  6. H

    Filtering in a Pivot Table

    my pivot table below has filters on column a and b but I need to filter by c and d. I can't figure out how to add the filter at the top of the column like a & b and the filter icon is greyed out. <colgroup><col><col><col><col></colgroup><tbody> A B C D EE# LS2 Values 10 1 BONUS...
  7. B

    Looking for help with a formula

    I currently have a spreadsheet that figures commissions based on one of two factors. 1. Mono-line commissions 2. Multi-line commissions I want to add, if possible, a way to divide the commission by 2 if it is a shared commission. This is the formula that I am using...
  8. 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...
  9. C

    Formula to Determine Sales Percentages - But Not That Simple

    We normally report sales as Total Goal & Total Digital Goal against Total Actual Sales & Total Actual Digital sales, weight both at 50% add them together then take that percentage and give a base percentage with an accelerator for any amount over. For example: <tbody> Goal Actual % to Goal...
    • cyd000
    • Thread
    • commissions impossible impossible? percentages
    • Replies: 3
    • Forum: Excel Questions
  10. B

    Progressive Commission Calculations

    <html> <head> <p class=MsoNormal>I am looking to create a formula to calculate progressive commission payouts. Can I create a payout that separates a full amount ($12,000 sale) in to 3 levels of payouts? See the example below, if I sell $12,000, and the first $5,000 is paid at 5%, from...

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