+ Reply to Thread
Results 1 to 4 of 4

Bonus Pool calculation/formula needed

  1. #1
    Registered User
    Join Date
    01-09-2017
    Location
    Independence, Missouri
    MS-Off Ver
    Home and Business 2013
    Posts
    2

    Bonus Pool calculation/formula needed

    Would like to have a cell calculate how much bonus money someone gets based on how efficient they did their job.

    Lets say the goal hours to complete a job is 100.
    If they complete the job in 100 hours no money goes in the bonus pool
    For every hour they can go under the 100 hr goal I would like to add 10.00 to the bonus pool.
    For every hour they go over the 100 hr goal I would like to subtract 10.00 from the bonus pool.

    Any ideas how to put this together?

    Thanks in advance!

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Bonus Pool calculation/formula needed

    Hi there,

    See if the attached workbook gets you moving in the right direction.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-09-2017
    Location
    Independence, Missouri
    MS-Off Ver
    Home and Business 2013
    Posts
    2

    Re: Bonus Pool calculation/formula needed

    perfect, thanks for the help!

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Bonus Pool calculation/formula needed

    Hi again,

    Many thanks for your feedback - glad I was able to help.

    Regards,

    Greg M

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula help for bonus calculation with minimum threshold?
    By wisey11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2015, 09:56 AM
  2. [SOLVED] Bonus Calculation
    By AZ-XL in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-14-2014, 06:56 AM
  3. Forecast Bonus Calculator - Require a formula to calculate the bonus' due
    By The_Snook in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-05-2013, 07:32 PM
  4. Bonus Calculation
    By DavidRainey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2013, 01:42 PM
  5. [SOLVED] Bonus Calculation
    By kasava in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2013, 08:08 PM
  6. Bonus Calculation
    By jonwool in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-28-2012, 07:16 AM
  7. Bonus formula help needed
    By jiffy97 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2005, 06:45 PM

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