Cumulative Tiered Bonus Structure

**dpleventhal** · 01-11-2011, 08:36 AM

Gotcha....but the lenders need to (want to) see how their revenue is being distributed throughout the year. It makes them feel better if they can see, for example, that they've maxed out the 1st tier & are now earning a 10% bonus on all additional revenue.

It's a feel good thing for them (& a pain in the rear for me)....

Thanks for your help DonkeyOte!!

**DonkeyOte** · 01-11-2011, 08:49 AM

With some thought you would be able to shorten the below but I suspect they do what you want:

G14:
=MAX(0,MIN(250000,SUM($G$13:G$13))-SUM($F14:F14))
copied across

G15:
=MAX(0,MIN(250000,SUM($G$13:G$13)-250000)-SUM($F15:F15))
copied across

G16:
=SUM(G$13)-SUM(G14:G15)
copied across