Help with formula pls!

[dmarquez]

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!

 

[rpaulson]

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

=a1+ a1*0.3*0.027

 

[dmarquez]

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?