Yeah it's the commission I'm trying to get working.
Just explaining this one is a difficult task in itself.
I'm getting near to a solution thanks to everyone's help. I'll attach my new workbook for you to have a look.
The problem now may be with the way the running totals are calculated.
The deal is, any profit 'over' target is paid at 40% once the unit target has been exceeded.
At the min once both running totals are over target the commission changes to 40% but say for instance the target is 100,000 and 100 units.
And 120,000 and 120 units was achieved, it would be 10% or 20% of 100,000 depending on contract state on or off, up to 100,000 and 40% of everything after.
So a base from 10,000 to 20,000 plus 40% of anything over target so 20,000 x.4 = 8000
So it would b between 18,000 and 28,000 in total.
At the minute my formula is checking previous month end running totals to check against target, I'm not sure I'm even approaching this one from the right angle.
|