I wasn't sure if this was the correct category, so I apologize in advance if this thread was created in the wrong place.
I'm trying to create a personal retirement financial planner program (similar to many readily available templates) from scratch as somewhat of a learning exercise. I have a table and I'm trying to enter the interest in the interest column. Each interest cell in the column is different, showing the accumulative interest pertaining to each row. I don't think too much detail is necessary, so I'll try to be as general as possible.
The formulas I'm using in the interest column are:
cell 1: =F27*$E$8
cell 2: =(F28+$G$28)*$E$8
cell 3: =(F29+$G$28+$G$29)*$E$8
cell 4: =(F30+$G$28+$G$29+$G$30)*$E$8
So with the above first 4 cells you can already see a pattern. I'm essentially adding another cell to a factor in the formula at each increment. In cell 2, cell G28 is added to the first factor. In cell 3, cell G29 is added to the first factor, and so on and so forth...
Short of manually copying and pasting each previous formula then manually adding each new cell to the formula at each interval, I'm not sure of a way to accomplish my task. Surely there must be a faster way, where I can just drag down for the autofill to do some work, right? Please let me know of the fastest way(s) of accomplishing this task. Don't hesitate to ask if you need me to elaborate on something.
Thank you!
Bookmarks