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