Remember Me?

#1
October 19th 06, 07:30 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 14
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
October 19th 06, 07:36 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,339
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
October 19th 06, 07:39 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,688
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
October 19th 06, 07:40 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,909
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Matt New Users to Excel 18 September 11th 06 10:15 AM daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM [email protected] Excel Worksheet Functions 1 June 12th 06 11:06 PM Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM

All times are GMT +1. The time now is 08:00 PM.