Hope you're all well.
I’m hitting a brick wall inserting a formula into a tracker for my sales teams commission structure which is being redone.
It’s a tiered system whereby the salesperson will get commission in brackets until they reach target, and then a higher percentage on anything over target; (0.1% for the first 20%) of their target, (0.2% on the next 20%), (0.3% on the next 20%) so on.
Until they reach target, at which point everything over target they are rewarded at 2%.
If they are under target, they will still receive commission, but only within the brackets.
If anyone who’s done a similar structure that would be able to take a look and let me know their thoughts, it would be really appreciated, as I seem to be going around in circles.
I've extracted a section and published it below.
Thanks in advanced, any suggestions welcome :D