Copying and applying formula to range of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)
Mike Rich said:
I have a column of 20 numbers that I would like to multiply by 35 and have
Click to expand...
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?
 
Mike said:
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!
Click to expand...
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
 
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
 
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


Mike Rich said:
I have a column of 20 numbers that I would like to multiply by 35 and have
Click to expand...
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?
 
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




Gord Dibben said:
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
Click to expand...
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?
 
Back
Top