formula, with constant cell, trouble with fill down

M

Municorn1977

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top