Formulas won't drag down the column

[Guest]

I have created a spreadsheet in there are values in A1-A10, D1-D10, etc. ,
then I have a constant value in A20. I then created a formula A1*A20 in cell
B1, and I would like to drap this formula down so that I get the following
result A2*A20, A3*A20...but when I drag the formula it gives me A2*A21,
A3*A22, A4*A23...Somebody please help!!!

 

[Guest]

Change A20 to an Absolute reference.

=A1*$A$20

The $ will prevent the reference from incrementing when the formula is copied.

HTH,
Elkar

 

[Don Guillett]

$a$20