View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default adding a percentage for COLA to Payroll worksheet

put 1.02 in a cell somewherecopyselect range to
changeeditpastespecialMULTIPLY

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"luvkisn" wrote in message
...
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%?