Excel slidescale commission structure

[Andre Becker]

Hi All,

I am struggling to do a function formula for a commission structure workbook. Basically what I want to do is this.

commission on sales
1-5 units=6% of profit
6-8 units=8% of profit
9-11 units=10% of profit
12+ units=12% of profit

if the units are within the first 1-5 then 6% if in 6-8 bracket then 8%, if in 9-11 bracket then 10%. etc

i was trying the IF function, but that only allows me 1 value to check and add, how would i use multiple IF?

 

[shg]

There are a bunch of examples at https://app.box.com/s/etysu13dpy3pl5i7f986

 

[L. Howard]

Try this:

A1 to A4 = 1,6,9,12
B1 to B4 = 6, 8, 10, 12

C1 = No. of Units
D1 formula is =VLOOKUP(C1,A1:B4,2,1)

Regards,
Howard

 

[Andre Becker]

Will upload pic or file for any help please. Not sure what I am looking for

 

[Andre Becker]

https://app.box.com/s/4ee1o9xcxwiay0855upn

here is the link to the file i am working on. basically i want cell D17 to be calculated based on the units in cell D16, then comparing to the different commission structures in cellrange B22-B25 and then calculating the commission based on D18*(result of calculation i.e 6,8 10 or 12%)

 

[Andre Becker]

None of these seems to be what i am looking for. please note my last post with link and explanation

 

[Andre Becker]

Figured it out.... Thanx