+ Reply to Thread
Results 1 to 2 of 2

complicated accounting formula

  1. #1
    Registered User
    Join Date
    09-18-2007
    Posts
    7

    complicated accounting formula

    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?

  2. #2
    Registered User
    Join Date
    09-18-2007
    Posts
    7
    Figured it out, had to add the bonus percentage to 100%, divide the original net profit by that, then multiply it by the bonus percent. I guess it wasn't that complicated. Woot!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1