| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying a mixed reference formula
This is best asked as an example. If I am using a mixed reference formula in
several cells ie cell B2 contains A2/A$1 and cell B3 contains A3/A$1, is there any way to copy the reference having it increase each time ie cell B5 contains A5/A$4 and cell B6 contains A6/A$4? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell reference in a formula is called | Excel Discussion (Misc queries) | |||
| copying a formula, the reference adjusts, but the result does not | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Threaded Mode
