+ Reply to Thread
Results 1 to 3 of 3

Adding bonuses to a, if then

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    NJ
    MS-Off Ver
    office 2011
    Posts
    5

    Adding bonuses to a, if then

    I am sure what I want to do is quite simple but I can not figure it out. I am creating a spreadsheet for my companies Bonuses throughout the year. I have a calendar type set up for each month with the dates up top and the employees on the side that adds up all the days that an employee is out. I want to set it up that if there is a zero under the quarterly bonuses column for that employee it will add how much the bonus is automatically. but if there is any number other than zero there nothing will be added

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Adding bonuses to a, if then

    It would help if you prepared a dummy worksheet and uploaded it (directions below) so we can see how your sheet is laid out.
    The formula would be something like this

    =IF(A5=0, formula for calculating bonus, 0)

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-18-2019
    Location
    NJ
    MS-Off Ver
    office 2011
    Posts
    5

    Re: Adding bonuses to a, if then

    That actually worked out perfectly! thank you so much! I appreciate it!

+ 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] how to add both bonuses for each person
    By eeps24 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2018, 12:11 PM
  2. Need help calculating Bonuses
    By Arturath in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2013, 08:13 PM
  3. Trying to calculate bonuses
    By LizConners in forum Excel General
    Replies: 1
    Last Post: 09-29-2011, 07:04 PM
  4. Employee Bonuses
    By dengar169 in forum Excel General
    Replies: 9
    Last Post: 12-24-2010, 03:04 PM
  5. Project Bonuses
    By Cortlyn in forum Excel General
    Replies: 2
    Last Post: 11-08-2007, 05:03 AM
  6. need to work out bonuses
    By Grd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2006, 04:10 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