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?