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?
|