I am trying to create a formula in Excel that calculates how much I need pay each employee for a bonus on a job they oversee. Bonuses are calculated on a sliding scale of percentages. If the net profit on a job is 1%, they receive 11% of that profit as a bonus. Both values increment +1% up to a 25% net/35% bonus, with a 35% bonus being the cap. However, their bonus is figured by the net AFTER their bonus is paid out. Is there any way to do all of this in a single formula?
Bookmarks