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

1. ## 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. ## Re: Help with formula pls!

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

=a1+ a1*0.3*0.027

3. ## 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?

## User Tag List

#### Posting Permissions

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