commission calculator

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

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

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

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

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

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

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

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