adding a percentage for COLA to Payroll worksheet

[luvkisn]

I have a worksheet that I have all of our positions and payroll figures. We
need to update by adding an annual COLA of 2%. How do I do this without
having to go into each cell and update by the 2%?

 

[Don Guillett]

put 1.02 in a cell somewhere>copy>select range to
change>edit>pastespecial>MULTIPLY

 

[Rajesh Mehmi]

If you can add a column then multiply by 1.02 in the added column

=payroll*1.02


regards
Rajesh Mehmi
(e-mail address removed)