Cumulative Tiered Bonus Structure

David, it's hard to determine what you want exactly.

The point I would make on these types of calculations is that's it's often easier to revert to a SUMPRODUCT approach - "cleaner" so to speak:

G21:
=SUMPRODUCT((SUM($G13:G13)>{0,250000,500000})+0,SUM($G13:G13)-{0,250000,500000},{0.05,0.05,0.05})-SUM($F21:F21)
copied across

would give you the quarterly commission values I believe ?
(using the cumulative "eligible fees" value as basis for calculation)

Originally Posted by DonkeyOte

David, it's hard to determine what you want exactly.

Thanks for your reply. Sorry I wasn't super clear on what I'm needing.

The area that I'm stuck on are cells calculating cells G14:J16.

I can't figure out how to make the eligible fees "build" on each other so that once you hit the bonus for that tier you are done for the year and any new fee revenue gets pushed to the higher tiers.

The point I was making was: that table (and in fact rows 14 to 20 inclusive) aren't required at all if you use the SUMPRODUCT suggestion.