Results 1 to 3 of 3

Thread: Help with formula pls!
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Help with formula pls!

    Hi All! I'm looking for some help in creating a formula for the following: A formula that will calculate the increase amount for an employee's salary. I need to be able to enter the increase percentage amount (i.e. 2.6%, 2.7%, etc. - this percentage will differ for each employee), the employee's current salary, and the spreadsheet should be able to automatically calculate either 30% of the 2.7% or the full 100% of the 2.7% based on the salary.

    So for example, if the employee is currently earning $40,000, what would 30% of 2.7% bring their salary up to?

    I hope I included enough information. Thank you in advance for your help!

  2. #2
    Board Regular rpaulson's Avatar
    Join Date
    Oct 2007
    Location
    Fremont, OH USA
    Posts
    1,044
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with formula pls!

    what'S the criteria if they get the 100% of the 2.7%?

    =a1+ a1*0.3*0.027
    Last edited by rpaulson; Jan 30th, 2017 at 05:05 PM.

  3. #3
    New Member
    Join Date
    Jan 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with formula pls!

    Thanks for your response! Not sure if I'm understanding correctly, however, if they 100% of the 2.7% the criteria would be the suggested increase amount which can always vary depending on the employee's job title. Does this make sense?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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