Forum Discussion
excel to help divide company profit into tiers with caps
hi there i need to understand how best to use excel to divide a pool of money into different tiers with caps. once the cap of 1 tier has been reached then the remaining pool would need to be split e...
Thanks for this. i see what you have dont though i am not sure why it cannot work without removing the cap of the highest level. none the less, would your template work for the situation i described in my reply to Riny-van-Eekelen below also? thank you!
If we 'respect' each cap, the total amount cannot be higher than 500 (tier 1) + 750 (tier 2) + 1000 (tier 3) + 5000 (tier 4) + 10000 (tier 5) + 15000 (tier 6) = 32250.
If there are 40 persons in the 500 tier, does that mean each of the 40 can get at most 500, or do the 40 combined get a total of at most 500?