using the $ to lock formulas

F

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.
 
F

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
 
J

JE McGimpsey

One way:

=INDIRECT("B2")

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