formula, with constant cell, trouble with fill down
 

I have a cell with a fraction put to decimal. When I use this cell in a
function and I Fill Down the cell that is used moves.
Ex.
cell D1 has the fraction.
B1 has equation =A1*D1
and I Fill Down the equation ends up =A2*D2 and =A3*D3 and so on
How do I keep cell D1 when I use the Fill Down?

formula, with constant cell, trouble with fill down
 

$D$1


Municorn1977 wrote:
I have a cell with a fraction put to decimal. When I use this cell in a
function and I Fill Down the cell that is used moves.
Ex.
cell D1 has the fraction.
B1 has equation =A1*D1
and I Fill Down the equation ends up =A2*D2 and =A3*D3 and so on
How do I keep cell D1 when I use the Fill Down?

formula, with constant cell, trouble with fill down
 

=A1*D$1
--
Gary''s Student - gsnu200771

formula, with constant cell, trouble with fill down
 

thanks

"Gary''s Student" wrote:

=A1*D$1
--
Gary''s Student - gsnu200771

formula, with constant cell, trouble with fill down
 

thanks

"Bob I" wrote:

$D$1


Municorn1977 wrote:
I have a cell with a fraction put to decimal. When I use this cell in a
function and I Fill Down the cell that is used moves.
Ex.
cell D1 has the fraction.
B1 has equation =A1*D1
and I Fill Down the equation ends up =A2*D2 and =A3*D3 and so on
How do I keep cell D1 when I use the Fill Down?