commission

  1. M

    IF calculation not working...what am I missing?

    Hello all, I was recently offered a sales job where the commission rate is based on the profit margin of the sale (specifically, no commission on sales with less than 20% margin, 20-29% margin = 10% commission, 30-32% = 12.5% comm., 33-39% = 15% and 40%+ margin = 18% commission); in trying to...
  2. M

    Help with If function

    So in general we are trying to calculate commission. I make 2% on anything thats is 15000 and less. Once I hit 15001 I make 5% on that. I cannot figure out the correct formula for the following. trying to figure out commission B3 = 16000 I need a formula thats tells me if B3 is less than or...
  3. R

    Vlookup and changing values

    Sorry dont know much about excel and trying to help a friend. Im using vlookup to try to calculate varrying commission percentages: when $0-100 sold money received is 1% of sale, $101-200 is 2% and so on until $501+ is 5%. The equation is =(VLOOKUP(B3,Sheet2!B3:C7,2,TRUE))*B3 When i try to...
  4. M

    Help with ticket sales with different commission levels.

    Hello, We run a MMA company out of Michigan and I had a question on how to set up a spreadsheet to help with ticket figuring. Here is the scenario I need help with. We sell the tickets for $20. Tickets are signed out to fighters and they sell them to make a cut. If they sell 1 ticket through...
  5. Q

    Help with Graduated Commission Formula

    After more Googling and experimenting then I care to discuss, I have run into a brick wall attempting to create a formula that can help me through my objective. I found a few threads with similar questions, but no answers, so am hopeful someone can provide direction. I am comparing several...
  6. C

    Work backwards from desired commission amount to find sales volume

    I have a tiered commission structure that is laid out as follows: <tbody> Tier 1 $1 30% Tier 2 $5,000 35% Tier 3 $10,000 40% Tier 4 $15,000 45% Tier 5 $20,000 50% Tier 6 $25,000 55% Tier 7 $30,000 60% </tbody> The commission percent is retroactive to $1. For example: If you...
  7. A

    Commission Spreadsheet

    Hello Everyone, I'm trying to work out the commission made on a total So for example: Cell U54 is the total commission. Then in Cell T57i would like it to work out the first £5000 at 12.5% Then in cell T58 i would like it to work out 5000-9000 at 15% Then in cell T59 i would like it to work...
  8. L

    Commission Breakdown for real estate agents, tried a million different ways...PLEASE HELP

    So I'd like Excel to help me create the following breakdowns, I've been doing it manually (which leads to errors). Tried "if" and "left" and such in Excel and can't seem to get the results I need. Please help Fields All Calculations are based on: Sales Price: cost of home Total % of Commission...
  9. J

    How to set up a Sliding Commission Calculator Formula

    I am trying to set up a formula for commission calculator to a cost workbook I have. Contract Price - $ 20,808.00 Actual Cost - $ 17,481.89 Gross Profit - $ 3,326.11 Gross Margin - 16% I would like for the commission to calculate if the gross margin is between 5% - 10% the commission...
  10. C

    Compounding Commission Schedule

    Hi All, I'm very new to this forum so please forgive me. I'm trying to create a compounding commission schedule that is as follows: 10% of the amount from $0 - $50,000 with a minimum of $1,000 5% of the amount from $50,001 – $100,000 3% of the amount from $100,001 - $250,000 2% of the...
  11. B

    Sales Commission Sliding Scale Calculator

    A B 1 Name Bookings 2 Integis $10,500 3 ABC Company $17,500 4 Today Company $30,000 5 anuary $58,000 Booking Scale Commission payout $15,000.00 10% $36,000.00 15% $45,000.00 20% $56,250.00 25% How would...
  12. M

    Rounddown to calculate qty. Qty dependent on variable units

    Hi Everyone I hope someone can help me with a problem I'm facing. I have a set amount of cash. Say 1000 (A1). I want to calculate how many units I can buy with this 1000. The units trade at a price of 1.5 (B1). However, the issue is that for purchasing these units I will need to pay a...
  13. F

    Help needed with insurance commission calculator using Vlookup

    I'm using an excel sheet for tracking new sales of insurance policies. I add a new line for each client, by product type, the sum of premium they will pay, I manually calculate the initial commission due and renewal commission due. But I want to reduce the manual calculations/errors of the...
  14. S

    Formula assistance please

    Hi, I have a formula used to calculate my waiters' commissions. This formula (below) automatically removes VAT. A recent system upgrade renders this useless, so I would like to change the formula to use the exact amount entered. Please assist, as this is a multi-page formula...
  15. N

    Commission Formula

    Hi, I own a Salon and wish to set up a commission spreadsheet for my employees. I know that there has to be a way to do this in Excel. I want to be able to set it up with one side being 75% and the other 25%. Meaning, my employees pocket 75% of the sale and I pocket 25%. I would like to be able...
  16. M

    Commission based formula

    Hi, I need a formula which will analyze a reps total gross commissions and determine what percentage they are eligible for commission payouts: For example, a rep gets paid a percentage of their incoming commission based on YTD performance: 0 - 51999 is 50%, 52000 - 72999 is 52%, 73000 - 99999...
  17. B

    Advanced Commision Calculator

    Hi Everyone, I'm trying to calculate the commission for work and I'm getting Really long formulas. it works like this Excel WorkbookIJKLMN77*IF****78*GPIF***79*0.25 on the total valueGPIF**80**0.25 on 300000GP>500000* * * * * * * *240,000.00*81**+ 0.3 on the difference0.25 on 300000* * * * *...
  18. P

    Tiered Commission Formual for a group of people

    Hi, I need to calculate the commission of my team, they get commission on credit card payments that they take. The tiers are: <TABLE class=MsoNormalTable style="MARGIN: auto auto auto -0.65pt; WIDTH: 217pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 0in 0in 0in"...
  19. F

    HELP, Commission Scedule

    I am trying to write a formula to calculate commissions. Employees collect 60% of sales up to a $25,000 threshold. After the $25,000 has been paid they collect 100% I am having a hard time getting Excel to calculate the sale at the point they cross the threshold and still accuratly calculate...

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