Calculating Wage Increases on a Sliding Scale

[ultra_xcyter]

First of all, I'd like to thank all of the contributors in this foru
for the wealth of information they have provided me in resolving m
Excel issues! Thanks to you all!

Now for the question: We are giving out raises to employees at m
company, but not everyone is getting the same percentage increase
because let's face it...some employees are better/worse than others
Anyway, some employees will get a 3% raise, some a 2% raise and some
5% raise and so on...Well, I've setup a column showing the curren
salary, a column showing the percentage increase that they are getting
another column showing the dollar amount of that percentage increase
and finally a column for their new & improved salary.

What I am wondering is, is there a formula that will allow me to jus
plug-in the percentage increase for a particular employee and have i
automatically calculate the actual dollar amount of the raise in th
column I have setup titled "$ Amount of Increase"? I know I coul
simply do a formula that multiplies the percentage by the curren
salary, but since the percentage increase will vary by employee tha
won't work. Is there a formula then that will automatically calculat
the dollar amount? I need a formula that will work no matter wha
percentage is entered in the percentage increase column.

Thanks in advance for your help

 

[{BoB} OZZIE]

what you described sounds like it would indeed work. if it
not, check your formula - if you see any $ signs, remove
them.

column "a" is current salary, column "b" is increase
percentage, column "c" is =sum(a1*b1)(gives the dollar
increase) column "d" is =a1+c1 (gives the revised salary).

copy the formula down. when the increase percentage
changes then the dollar increase and the reveised salary
will change..