Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying a column of data by a constant
I am budgeting costs for the upcoming year. There is a column of data that
corresponds to the employee's health insurance cost that is keyed in data (not a formula). I want to multiply each cell in this column by 1.1 to project a 10% increase in cost. Is there quick way to do this without creating a new column and pasting over the original? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying a column of data by a constant
Put 1.1 in a spare cell and COPY this cell.
Highlight your column, then do Paste Special =[Operation]==Multiply Delete 1.1 from your "working" cell HTH "Zach" wrote: I am budgeting costs for the upcoming year. There is a column of data that corresponds to the employee's health insurance cost that is keyed in data (not a formula). I want to multiply each cell in this column by 1.1 to project a 10% increase in cost. Is there quick way to do this without creating a new column and pasting over the original? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying a column of data by a constant
Try this:
Enter 1.1 in an empty cell Copy that cell: EditCopy Select the range of cells you want to increase Goto EditPaste SpecialMultiplyOK Delete the 1.1 Biff "Zach" wrote in message ... I am budgeting costs for the upcoming year. There is a column of data that corresponds to the employee's health insurance cost that is keyed in data (not a formula). I want to multiply each cell in this column by 1.1 to project a 10% increase in cost. Is there quick way to do this without creating a new column and pasting over the original? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying a column of data by a constant
Zach
Put 1.1 in an unused cell. Copy it. Select your data range and EditPaste SpecialMultiplyOKEsc. Delete cell with the 1.1 Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 11:30:02 -0700, Zach wrote: I am budgeting costs for the upcoming year. There is a column of data that corresponds to the employee's health insurance cost that is keyed in data (not a formula). I want to multiply each cell in this column by 1.1 to project a 10% increase in cost. Is there quick way to do this without creating a new column and pasting over the original? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with referencing please | New Users to Excel | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Stock data manipulation | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions |