Hi,

Use C1 as an absolute reference. For eg. in cell A2, if you want
multiply the value in cell C1 by 10, instead of using =C1*10 use

=$C$1*10.

You can make a cell reference absolute by pressing F4 key.

Regards

Govind.

Phill Costello wrote:
in excel i have a value in C1 which is my 'constant' value and i have a list
of variable values in cells A2 to A40 which i then want to calculate which I
can do however i can not get the formula to auto calc when copying the cells
it give me the wrong values. ANy help please by direct reply to phill
costello at