Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula a1=b1+c1 inserting column after a1 changes formula a1=c1.
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Search column and move text formula | Excel Discussion (Misc queries) | |||
column to row in formula | Excel Worksheet Functions | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |