# commission calculator

1. ### Formula for commission structure

Hi, I would like a formula for a commission structure. Say C5 to C16 are months of the year with sales figures per month for which commission is paid. I would like the formula to work out the commission I would get each month. The end of the formula on months after January will then minus the...
2. ### Commission Calculator based on total Amount of Sales

I need help with creating a formula for this commission structure. The Initial formula I came up with is this. =IF(K7>\$K\$4,(K7-K4)*\$K\$5,0) I also need the calculation for anything above 100000 combined with this initial formula that I created so that if the amount exceeds 100000 it would not...
3. ### Commission Per Sale + Tiers

Hi Guys, I was hoping you'd be able to help me with a formula to calculate monthly commissions for my team. My team are paid per sale with the amount of commission increasing at different tiers. 0-5 sales = \$0 per sale 6-55 sales = \$25 per sale 56+ sales = \$50 per sale 55 would equal to 100%...
4. ### Commission Calculating Formula HELP

Hey guys. I'm having a lot of trouble with a formula to calculate commissions for my sales team. This is how it works, we have five sales representatives in the team: Sales Rep1 Sales Rep2 Sales Rep3 Sales Rep4 Sales Rep5 Ok. So each one of them has a minimum sales goal monthly. IF they...
5. ### 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...
6. ### Help with a variable commission calculator

Hello all, new to the forum and posting a question about commission calculations. I have been using an IF formula to calculate variable commissions but this is proving to be a little unwieldy and wondered if there was a better way to generate the figures. Company has various bands for...
7. ### Commission Tracking

I need help tracking commission on a recurring basis, but also on a sliding scale based on the month. I've been struggling with this for two weeks now, and have only come up with a temporary "just to get by" spreadsheet. I'm at my wit's end and now only dream in formulas, tables and...
8. ### Commission Rate by margin formula HELP!

Hello, I'm having a heck of a time figuring out how i can set up my commission rate in excel for my company. Our scale is as follows: Margin % is in cell F7 Profit Dollar amount is in cell F6 under 20% margin pay 15% commission on profit 21% to 30% margin pay 20% commission on...
9. L

### Calculate tiered commisions on commulative monthly sales

Hi - I have done a lot of reseach regarding tiered commision formulas in excel but none of them addresses how to calculate tiered commisions on cummulative monthly sales. The annual quota is \$1,200,000. There are four commision tiers 0 - 80% of quota = 3% commision 80%- 100% of quota = 9%...

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

### Which adblocker are you using?

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

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