+ Reply to Thread
Results 1 to 8 of 8

Final Salary to Show in a Different Cell.

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2016
    Posts
    55

    Final Salary to Show in a Different Cell.

    Hi,

    Good day!

    I'm doing this scenario in Excel:

    The Column B2 in the Final Payout sheet would get the value from the Salary sheet Column I18.
    The Salary sheet computes the salary of each employee after the user types its name in Salary sheet Column C1.
    After the user sees the final payout, Salary sheet I18, the user would manually type it in Final Payout sheet Column B2. Once done with the first one like John, he would now go to the next, manually copying the value from Salary sheet Column I18 to Final Payout sheet columnB2

    Is there a way to do this using formula without manually typing the final salary of each employee since it would be in hundreds?
    Then it should also write the Tier as well to Column C2 coming from Final Payout H21, H22.

    I tried but to no avail. Please help.

    Hope you could assist me with this. Thank you in advance.
    Last edited by thebrucekt; 10-31-2017 at 11:46 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Final Salary to Show in a Different Cell.

    Please explain why the employee needs to do this. Surely you can calculate these values on the final payout sheet from the data tab?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    10-16-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2016
    Posts
    55

    Re: Final Salary to Show in a Different Cell.

    Hi AliGW,

    Good day!

    The reason for this is that say I'm the one taking care of the salary computations of employees:
    1. I would go to Salary Sheet, then type the name of the employee in cell C1.
    2. After typing then employee's name, everything will be auto populated including cell I18 and a cell in range H21:H31
    3. The current process now for instance is, I manually type the values from cell I18 and whatever cell is highlighted from the range H21:H31 which time consuming if you'll be doing this for 100 or more employees.

    The preferred process would be if possible (I've been trying but couldn't make it work for the past days):
    1. The value in cell C1 would autopopulate in the Final Payout sheet cell B2 for John and the other employees
    2. The value in range H21:H31 would populate in Final Payout sheet cell C2 as well for the respective employee

    This is one way of doing check and balance if the numbers are correct and I would, if I may, use the information that I'm getting from the Salary sheet as well to show in the Final Payout sheet.

    I hope you could assist me with this. Your help would be much appreciated.

    Thank you in advance.

  4. #4
    Registered User
    Join Date
    10-16-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2016
    Posts
    55

    Re: Final Salary to Show in a Different Cell.

    Hi AliGW,

    Good day!

    I'm trying your suggestion too...

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Final Salary to Show in a Different Cell.

    Great - let us know how you get on.

  6. #6
    Registered User
    Join Date
    10-16-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2016
    Posts
    55

    Re: Final Salary to Show in a Different Cell.

    Hi,

    I was able to work on the others except for this:

    If the employee's Attainment Bonus (D11) for example is 250%, which falls
    between the range of cell N21 and O21, the employee will get a bonus salary of $400
    in the Salary sheet.

    This should highlight the correct cell in Column H21:H31 and add to Data sheet M2
    column for that employee and show the tier number in Data sheet column O2.

    Hope you could help.

  7. #7
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Final Salary to Show in a Different Cell.

    Hi @thebrucekt

    I suppose you need use pivot tables. The designed solution is hard to maintain. In my opinion, the names of the columns and fields should be reviewed

    In Sheet 'Salary' change G21:G31 to 399%, 299%, ... , 100%

    In Sheet 'Salary' cell I10, use this formula to get the Performance Bonus
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In Sheet Calculator use
    in C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In N18 use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In the Attached file I made a little approach to use pivot tables (see Sheets Tab1 and Tab2)
    Note: day 28-10-2017 are to be considered?

  8. #8
    Registered User
    Join Date
    10-16-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2016
    Posts
    55

    Re: Final Salary to Show in a Different Cell.

    It worked perfectly Jose Augusto! My apologies for the late reply...

+ 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] Need formula for prorating monthly salary based on hire/fire date and annual salary.
    By Excel_Help_Pls in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-06-2015, 12:56 AM
  2. Replies: 2
    Last Post: 05-27-2014, 01:17 AM
  3. Replies: 8
    Last Post: 09-06-2013, 05:57 AM
  4. Replies: 3
    Last Post: 07-26-2012, 04:11 PM
  5. formule that will show the lowest salary
    By mstfztrk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-30-2012, 08:43 AM
  6. Plus and Minus signs to show up in final answer
    By Rayaus65 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-21-2010, 05:32 AM
  7. Show final decimal place digit when it is zero?
    By Jacks in forum Excel General
    Replies: 3
    Last Post: 10-15-2008, 04:20 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