Have you looked at what happens to that formula if you insert a new row
before row 3, Otto?

The INDIRECT() solution suggested in an earlier reply makes sense.
--
David Biddulph

"Otto Moehrbach" wrote in message
...
Change your formula to:
=1000-$B$3
HTH Otto

"Hook''em 2006" wrote in message
...
How do I keep the value range constant in a formula when I insert new
rows?
I have a constant value, 1000 and I need to subtract the value in cell
B-3
daily. I have the formula set up as =SUM(1000-B3). Whenever I insert a
row,
the formula adjusts B3 to B4 - I need for it to stay B3 even after
inserting
new rows.