Multiply by a constant

[Guest]

I want to multiply a group of cell's by a constant in anouther cell. If I
drag the bottom right corner it changes the referenced cell. Isn't the "$"
somehow used in this function?

 

[Guest]

Yes, you can use

=A1*$B$1

where B1 holds the constant

another way woul be to copy B1, select the range and do edit>paste special
and select multiply

Regards,

Peo Sjoblom

 

[Guest]

If the constant is located in a specific cell, then use $a$1, for example. )

 

[Frank Kabel]

Hi
=A1*$B$1
if B1 is your constant value. see:
http://www.cpearson.com/excel/relative.htm