Not sure if this can be done, but...

E

Excel Hates Me

I want to take a series of entries in one colunm and multiply each on
by the same number.

For exmaple, if I had a column with the entries 1 2 and 3, I'd like t
be able to create a new column with the entries 2 4 and 6

Any help greatly appreciated
 
C

Chip Pearson

If I understand your question correctly, you can do the following. Enter 2
in some empty cell and copy it. Then, select the cells that you want to
multiply by 2. Next, go to the Edit menu, choose Paste Special and select
the Multiply option. Finally, clear the cell with the '2' in it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
R

RagDyer

<"create a new column with the entries 2 4 and 6">

Original numbers starting in A1,
In B1 enter:
=A1*2
Click and drag down to copy as far as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message
I want to take a series of entries in one colunm and multiply each one
by the same number.

For exmaple, if I had a column with the entries 1 2 and 3, I'd like to
be able to create a new column with the entries 2 4 and 6

Any help greatly appreciated.
 
Top