Multiply by a constant
 

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?

Yes, you can use

=A1*$B$1

where B1 holds the constant

another way woul be to copy B1, select the range and do editpaste special
and select multiply

Regards,

Peo Sjoblom

"flotowntiger" wrote:

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?

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

"flotowntiger" wrote:

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?

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

--
Regards
Frank Kabel
Frankfurt, Germany

"flotowntiger" schrieb im
Newsbeitrag ...
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?