| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
relative reference
I have a cell formula =SUM(I4,-F4) which is in cell J4. If I insert a
column so that j moves to k, I want the formula to adjust to =SUM(J4,-G4). Is this possible, and if so how? thanks...charlie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Circular reference | Excel Discussion (Misc queries) | |||
| Copying a mixed reference formula | Excel Discussion (Misc queries) | |||
| international absulute cell reference | Excel Discussion (Misc queries) | |||
| Relative Reference | Excel Discussion (Misc queries) | |||
Threaded Mode
