#### madmansgates

##### New Member

- Joined
- Jul 2, 2010

- Messages
- 8

Is there a way of getting excel to work out monthly commission on the following basis:

Commission rates:

0 - 20,000 - 10%

20,001 - 40,000 - 15%

40,001 - 60,000 - 20%

60,001 - 25%

In any 3 months commission is paid monthly depending on sales per month over 3 months commision hurdle.

eg: Month 1 Sales of 15k is 15k@10%=1500 commission

Month 2 sales of 20k will have commision of 5k@10%(to reach 20k hurdle) and 15k@15% =total of 2750,

Month 3 sales of 10k will have commission of 5k @15% (40k hurdle) & 5k at 20% total of 1750

Any help would be appreciated

Thanks