using the $ to lock formulas

[frankmlr]

We are using the $ to lock the formula but when columns
are inserted the formula still changes. How do we correct
this?


Thank you for any assistance you can give.

 

[Frank Kabel]

Hi
one way would be to use something like
INDIRECT("A1")
to always refer to cell A1. Note: copying this formula won't change the
cell reference

 

[JE McGimpsey]

One way:

=INDIRECT("B2")

will always refer to the value in B2, even if you insert columns or rows.