| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to paste formula but reference a fixed cell
I'm trying to paste a formula to a row, have the formula reference the
current cell as well as a fixed cell (instead of automatically incrementing). For instance, if I were program cell C1 to be: = sum(A1/C1), and want to copy it to the whole row, incrementing the denominator but not the numerator so that you would get: sum(A1/C2) sum(A1/C3) how would you do it? Thanks. hr |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Getting rid of a circular reference error message | Excel Discussion (Misc queries) | |||
| Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
