total based on one constant value
 

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

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

Govind,

Thanks for the assist. I will try and let you know the result, but I am sure
it will work. In the mean time I have taken the constant value of $1.50 and
made it multiply this amount by the other variable cell such as :
=sum(1.50*a5)
Regards,

Phill Costello


"Govind" wrote:

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

G,

I have tried the formula you stated and I did not get it to work perhaps I
am doing something wrong.???

"Govind" wrote:

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