Retroactive commission % increase

[sargon99]

Hi, I have bee trying to figure out how to increase the commission % in in previous rows when reaching a threshold.

An example is deals through rows 1-5 are at 25%. rows 6 to 11 are at 30% and rows 12 and up are at 35%. once the tier is achieved the commission rate is changed back to the first row. Is this doable?

Thanks

 

[maabadi]

Please show Example file with XL2BB addin or image.

 

[sargon99]

Hope this helps

 

[sargon99]

Sorry about the last picture,

This will show rows I & J. Column I could be the standard 25% and Column J could be the increase in %.

Thanks in advance for any help in this matter.

A	B	C	D	E	F	G	H	I	J	K	L	M	N
NEW	STOCK	FLAT	DEMO	COST	PAC 1.5%	GROSS	COMM GROSS	COMM PAID	COMM BONUS	10- 14 $50 - 15 $100	F&I GROSS	CXI	ALLOWENCE
1 - 25%	802994.00	200.00		42303.22	634.55	792.50	157.95				1359.00		40.00
2.00	M001097	200.00		28279.81	424.20	893.51	469.31				85.00		40.00
3.00					0.00		0.00
4.00					0.00		0.00
5.00					0.00		0.00
6 - 30%					0.00		0.00
7.00					0.00		0.00
8.00					0.00		0.00
9.00					0.00		0.00
10.00					0.00		0.00

 

[maabadi]

Please Reply.
You want to First 5 cell at column I , would be 25% * Cost , Then no 6 -10 30% * Cost.
For Column J no.1 to 5 , would be 25%, 26% , 27% , 28%, 29% * Cost respectively.
Do I tell Correct?

 

[sargon99]

Please Reply.
You want to First 5 cell at column I , would be 25% * Cost , Then no 6 -10 30% * Cost.
For Column J no.1 to 5 , would be 25%, 26% , 27% , 28%, 29% * Cost respectively.
Do I tell Correct?

Quit honestly I could leave column I at 25% for all of the rows. Column J would show the extra % earned.

Example deal 1-5 0% bonus, once deal 6 is inputted, deal 1-6 show the extra 5%. all deals up to 11 would have the 5% bonus. Deal 12 and up would show 10% bonus from the first deal up to the final deal.

deal 1- 5 = 25%, once we achieve deal 6, it becomes 30% instead of 25% for deal 1-11. Once we hit deal 12, all deals become 35% all the way back to the first deal.

Thanks you again for trying to help.

 

[maabadi]

You can Use this formula. I don't Understand exactly what column you want multiply at commision. I suppose it column E. if not change column E to your column.
Enter this at J4 and drag it down:

=(INT(COUNT($E$4:$E$1000)/5)*0.05+0.25)*E4

 

[sargon99]

Thanks, will try it!