Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I've read through lots of similar posts but they don't all seem to reflect what I'm trying to do. I'm building trying to build a sheet that calculates commission based on sales for a given month. Cell d2 would have monthly sales target, Cell E2 would have the sales result in F2 I would like to put the formula.
The model is as follows
The model is as follows
- 15% commission of all revenue between 0% and 100% of monthly target only when 50% of monthly target is achieved. No commission is paid unless 50% of monthly target is achieved.
- 30% commission on all revenue between 100% and 150% of monthly target
- 35% commission paid on revenue above 150% of monthly target.