Hi!

Try this:

=C1*$D$1+742

If you were to insert a new row 1 the formula would automatically adjust for
the row insertion and become:

=C2*$D$2+742

If you still want the formula to refer to D1 in those situations:

=C1*INDIRECT("D1")+742

That will ALWAYS refer to D1 no matter what you do.

Biff

"Tom Hardy" <u23040@uwe wrote in message news:61c912b0d9c5c@uwe...
Probably simple, but I can't find answer. I want to copy a formula from 1
cell to a lot of other cells. When you do this, any cell addresses in the
formula change based on where you copied the formula to. How can I make 1
of
the cell addresses in the formula stay the same no matter where I copy it?
It
would be a "constant" in my formula and only changed from a "data entry
sheet".

Thanks, Tom

Example: In A1 I might have: =(C1*D1)+742
If I move this to A2, it will become: +(C2*D2)+742

I want D1 to remain the same. ??????