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.