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

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

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Gordon wrote:
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.

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Well, maybe not the *only* way:


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

or

A1: =INDIRECT("B1") + C1

or whatever combination is desired.

In article ,
Gordon wrote:

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.