total based on one constant value

P

Phill Costello

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 [email protected]
 
G

Govind

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.
 
P

Phill Costello

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
 
P

Phill Costello

G,

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