Thread: Inserting rows without changing formula values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hook''em 2006 Hook''em 2006 is offline
external usenet poster
  
Posts: 1
Default Inserting rows without changing formula values
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.
Reply With QuoteReply With Quote