Andre Becker
New Member
- Joined
- Jan 6, 2014
- Messages
- 5
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?
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?