# Excel slidescale commission structure

#### Andre Becker

##### New Member
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?

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### L. Howard

##### Well-known Member
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

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

#### Andre Becker

##### New Member
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

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

#### Andre Becker

##### New Member
Figured it out.... Thanx

Replies
9
Views
249
Replies
1
Views
397
Replies
3
Views
101
Replies
30
Views
2K
Replies
7
Views
155

1,195,858
Messages
6,011,978
Members
441,661
Latest member
Pammie007

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