| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying a formula and changing ONE value...
I have a formula that needs to be in litterally hundreds of cells on a
worksheet. The formula is: =SUM(E23/((E18/E17)*(1-A25))) The thing is, the formula needs to differ on every cell, but only in one place; the "A25" cell needs to change, like so: =SUM(E23/((E18/E17)*(1-A25))) =SUM(E23/((E18/E17)*(1-A26))) =SUM(E23/((E18/E17)*(1-A27))) Is it possible to do this easily? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying a formula | Excel Discussion (Misc queries) | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
| Changing the Color of a Word in Formula | Excel Worksheet Functions | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions | |||
Threaded Mode
