Formula Writing

[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

 

[Jean-Paul Viel]

HI,



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



Insert = Name = Define.



When cells move name move with them.

 

[Bernard Liengme]

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