copy formula from cell above

S

Sooky-la-la

I have a formula in a cell A1x3, how do i copy it to cells below, without
having to change it to A2 x3, A3 x 3 etc?
 
T

T. Valko

A1x3

Whatever "x3" is supposed to represent try expressing it like this:

A1x$3

As you copy down a column the reference to A1 will increment while "x$3"
will remain constant:

A1x$3
A2x$3
A3x$3
A4x$3
 
F

FloMM2

Sooky-la-la,
If you want it to stay A1x3 (cell A1 times 3), then
the formula will look like this "=$A$1*3".
The "$" before the column letter, in this case "A" keeps it in "A" column.
The "$" before the number, in this case "1" keeps in in that row.

hth
 
Top