Commision Calc

[Welsh Mark3]

I'm trying to create a Commission Calculator. The plan is 0 commissions is paid until 90% of target achieved, when 90% achieved 1% is paid on all sales, 95 - 100 is 1.5%, 1000 - 105% is paid at 2% and above 105% we pay 2.5%

 

[VBA Geek]

you could set up something like this:

Excel 2013
	A	B	C	D
1	Sales		Target:	1,000 €
2	100 €
3	200 €		35 €
4	500 €
5	600 €
6	1,400 €	TOT
Sheet3

Cell Formulas
Range	Formula
C3	=LOOKUP(A6/D1,{0,0;0.9,0.01;0.95,0.015;1,0.02;1.05,0.025})*A6
A6	=SUM(A2:A5)