excel help

A

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
 
F

Frank Kabel

Hi
try
=A1*$C$1

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

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.
 
G

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.




.
Click to expand...
 
Top