| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Problem with dragging formula down a column
Let' take a simple example:
PRINCIPLE: (cell C3) INTEREST RATE: (cell D3) YEAR 1: =SUM(C3+((C3*D3)/100)) OK, everything is fine. Drag it down by itself at you get =SUM(C4+((C4*D4)/100)) Now you have to go back and change the 4 to a 3. I have something far more complicated than this. The central problem is the drag down. I tried holding down the option key but that gives funky results. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem dragging formulas | Excel Discussion (Misc queries) | |||
| Code for dragging the last column | Excel Worksheet Functions | |||
| Excell dragging formula to change sheet/tab not column/row | Excel Worksheet Functions | |||
| Need keystrokes equivalent to dragging one column heading onto ano | Excel Discussion (Misc queries) | |||
| dragging a formula down a column | Excel Worksheet Functions | |||
Threaded Mode
