| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding a percentage for COLA to Payroll worksheet
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%? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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%? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding a percentage for COLA to Payroll worksheet
If you can add a column then multiply by 1.02 in the added column
=payroll*1.02 regards Rajesh Mehmi "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%? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a percentage to a figure | Excel Worksheet Functions | |||
| Adding payroll stubs payroll calculator | New Users to Excel | |||
| Australian "Payroll Calculator" worksheet?????? | Excel Worksheet Functions | |||
| want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
| adding letters in a payroll calendar | Excel Discussion (Misc queries) | |||
Linear Mode
