formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
 

in my spreadsheet when i fill down the formula i want it to use one cell and
mulitply it by the row.

How do i do this, please help its driving me mad!

formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
 

tRY THIS AND DRAG DOWN

=$A$1*A2

mIKE

"Coolchick" wrote:

in my spreadsheet when i fill down the formula i want it to use one cell and
mulitply it by the row.

How do i do this, please help its driving me mad!

formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
 

Use

=A$1*A2 and fill down

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Coolchick" wrote in message ...
| in my spreadsheet when i fill down the formula i want it to use one cell and
| mulitply it by the row.
|
| How do i do this, please help its driving me mad!

formula (a1*a2) filling down becomes (a2*a3) i want (a1*a3) Help!
 

Go into Excel help and look at the difference between absolute and relative
addressing for cell references.
--
David Biddulph

"Coolchick" wrote in message
...
in my spreadsheet when i fill down the formula i want it to use one cell
and
mulitply it by the row.

How do i do this, please help its driving me mad!