Hi:

I am trying to write a formula to calculate a annual amount of increase
of wages.

For example: I have a list of Current Wage rates. I also have a list
of proposed wage rates. I want to take the difference between the two
columns *2080 (if its an hourly person) or *1 (if a salary person).
Then, I want a total of this calculation for all the rows in the
columns.

So, if I have 4 people getting an hourly wage increase of $.50 (which
is the difference between the two columns) and I have 1 person getting
a $1000 per year increase, the number I am looking for should calculate
to be $5160 - annual amount of increase in wages.

Any thoughts?

Deb


--
dah
------------------------------------------------------------------------
dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=470942