Case One Case Two
A B C D A B C D
1 =C1 3 1 =C1 5 3

In Case One, the value for B1 is 3. When a new column C
is inserted (Case Two), the formula in B1 is automatically
changed to =D1, and the value remains 3. Is there a way
to write the formula so it retains the intent of =C1 after
the new column is inserted - such that the value in B1
would now equal 5?
=$C$1 doesn't work - it too changes to =$D$1.
Thanks,
Phil