Copying and applying formula to range of cells

[Mike Rich]

I have a column of 20 numbers that I would like to multiply by 35 and have it display in the cell to the right of the value being multiplied. Is there an easy was to enter a formula that would do this without having to type the formula for every single one?

Thanks for any help!

 

[Don Guillett]

one way.

Sub multiplyem()
For Each c In Range("a1:a20")
c.Offset(, 1) = c * 35
Next
End Sub


--
Don Guillett
SalesAid Software
(e-mail address removed)

I have a column of 20 numbers that I would like to multiply by 35 and have

it display in the cell to the right of the value being multiplied. Is there
an easy was to enter a formula that would do this without having to type the
formula for every single one?

 

[Alan Beban]

I have a column of 20 numbers that I would like to multiply by 35 and have it display in the cell to the right of the value being multiplied. Is there an easy was to enter a formula that would do this without having to type the formula for every single one?

Thanks for any help!

You can copy the column one column to the right, then put 35 in a cell,
edit|copy that cell, highlight the column, edit|paste special|Multiply,
escape

Alan Beban

 

[Gord Dibben]

Mike

Very rarely do you have type a formula to increment it down a column or across
a row.

Say numbers are in A1:A20

In B1 enter =A1*35

Double-click on the fill-handle at bottom right of B1 to increment the formula
down the column.

You could also just select the fill-handle and drag/copy down the column.

The fill-handle is the black lumpy square. If you don't see one when you
hover over the cell, go to Tools>Options>Edit and check "Allow drag and drop".

Gord Dibben Excel MVP


On Sun, 20 Jun 2004 14:56:01 -0700, Mike Rich <Mike

 

[DDM]

Mike, I see you got three replies (and counting), each of which takes a
different approach. Well here's a fourth.

If your numbers are in A1:A20...
Select B1:B20
Type =A1*35
Press Ctrl+Enter

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I have a column of 20 numbers that I would like to multiply by 35 and have

it display in the cell to the right of the value being multiplied. Is there
an easy was to enter a formula that would do this without having to type the
formula for every single one?

 

[CLR]

AND.................you can do everything Gord says until you get tired of
"35" being your magic number..........in that case insetad of =A1+35, you
can use =A1+C1 and then just type your "35" or any other number you want in
C1, and it will take the place of the "35" in ALL the formulas
automatically...............

Vaya con Dios,
Chuck, CABGx3

Mike

Very rarely do you have type a formula to increment it down a column or across
a row.

Say numbers are in A1:A20

In B1 enter =A1*35

Double-click on the fill-handle at bottom right of B1 to increment the formula
down the column.

You could also just select the fill-handle and drag/copy down the column.

The fill-handle is the black lumpy square. If you don't see one when you
hover over the cell, go to Tools>Options>Edit and check "Allow drag and drop".

Gord Dibben Excel MVP


On Sun, 20 Jun 2004 14:56:01 -0700, Mike Rich <Mike

have it display in the cell to the right of the value being multiplied. Is
there an easy was to enter a formula that would do this without having to
type the formula for every single one?