+ Reply to Thread
Results 1 to 4 of 4

Working out a bonus

  1. #1
    Registered User
    Join Date
    11-22-2009
    Location
    belfast
    MS-Off Ver
    Excel 2003
    Posts
    15

    Working out a bonus

    Edited..............
    Last edited by narl; 12-02-2015 at 09:13 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,814

    Re: Excel bonus

    Well, isn't that just:

    =(number of days) * (bookings per day)

    ??

    Put appropriate cell references in the formula instead of the text.

    Hope this helps.

    Pete

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Excel bonus

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    11-22-2009
    Location
    belfast
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Excel bonus

    I thought that at first, although the bonus would be variable, and would reduce money wise if you are off on annual leave, would also change monthly again based on working days, Monday through Friday

    Quote Originally Posted by Pete_UK View Post
    Well, isn't that just:

    =(number of days) * (bookings per day)

    ??

    Put appropriate cell references in the formula instead of the text.

    Hope this helps.

    Pete

+ 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. [SOLVED] calculate bonus at 30% of a figure, negative figures to be given 0 bonus.
    By jitterbug888 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-01-2015, 10:40 PM
  2. help required in excel to auto calculate a bonus structure
    By landyjay in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-28-2014, 01:49 PM
  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. [SOLVED] Excel Formula to work out bonus
    By 1078jessica in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2013, 04:35 AM
  5. Excel Spreadsheet for Bonus Structure Based on Sales
    By brookie1988 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-12-2013, 07:51 AM
  6. Excel 2010: One off Bonus Paymets Depending on Production
    By alexhare in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-17-2013, 06:46 PM
  7. Calculating a Sales Bonus When the Bonus Rate Changes as Sales Change
    By daydreamz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2012, 11:52 AM

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