excel help

[andre]

i have values in column A (from A1 - A100) which i want to
multiply by a value in C1. when i copy down the formula it
increments the A1 * C1, A2*C2, A3*C3.
i want it to only multiply by C1

 

[Frank Kabel]

Hi
try
=A1*$C$1

have a look at 'absolute/relative' references in the Excel help

 

[Andy B]

andre

You need to use an absolute cell reference. This means that instead of using
C1 you use $C$1, which fixes the reference to that cell, wherever the
formula is copied.

Andy.

 

[Guest]

thanks that worked

-----Original Message-----
andre

You need to use an absolute cell reference. This means that instead of using
C1 you use $C$1, which fixes the reference to that cell, wherever the
formula is copied.

Andy.




.