Formulas won't drag down the column

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!!!

$a$20

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Sara" <Sara@discussions.microsoft.com> wrote in message
news:05097653-B89F-4700-B586-A7FAF2FE0518@microsoft.com...
>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!!!

Change A20 to an Absolute reference.

=A1*$A$20

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

HTH,
Elkar


"Sara" wrote:

> 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!!!