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

G

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
 
G

Gordon

Gordon said:
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
Click to expand...

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

JE McGimpsey

Well, maybe not the *only* way:


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

or

A1: =INDIRECT("B1") + C1

or whatever combination is desired.
 
Top