Formula Writing

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

I am trying to make a spreadsheet that will automatically
calculate things for me. The only problem is, we will be
reorganizing it many different ways, so I can't just have
it use something like "=D1+D3" because the position of the
fields I will use will change many times. Is there a way
that It will make sure it stays with the correct field? I
am using Excel 97. Thanks
 
HI,



Give a name to your cell like D1 being Sale and D3 Taxes.



Insert = Name = Define.



When cells move name move with them.
 
If you write =D1+D3 in say E5 and then insert a column between A and B then
your formula will automatically adjust to =E1+E3.
If you Cut and Paste D1 to J1, the formula will automatically adjust.

Maybe we need more info on what is meant by "the position of the fields will
change many times"

Bernard
 
Back
Top