formula a1=b1+c1 inserting column after a1 changes formula a1=c1.

[Guest]

 

[Gordon]

darshan wrote:
<nothing>

PLEASE write your question in the BODY of the post.

In answer to your question, what do you expect it to do? If you want
ABSOLUTE formula references, use A1=$B$1+C1

 

[Gordon]

darshan wrote:
<nothing>

PLEASE write your question in the BODY of the post.

In answer to your question, what do you expect it to do? If you want
ABSOLUTE formula references, use A1=$B$1+C1

And in fact that doesn't work either.
The only way to do that is to do a Find and Replace after you have
inserted the column.

 

[JE McGimpsey]

Well, maybe not the *only* way:


A1: =SUM(INDIRECT("B1:C1"))

or

A1: =INDIRECT("B1") + C1

or whatever combination is desired.