Incrementing while adding cell components to formula

[sirdeity]

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!

[pike]

Hi sirdeity
Welcome to the forum
Can you please change your location to something less agressive

Please Login or Register  to view this content.

fill down

[sirdeity]

Brilliant. Thank you very much!

[pike]

your welcome

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[sirdeity]

I have another question I'd like to ask while this thread is still active. How do I create macros? I want to create a macro or button of some kind so the user can click something to generate random numbers in cells of my choosing. Ideally, the random number generated should fall within some range which the user is able to change. I've seen similar functions in templates, but I haven't figured out how it was done yet.

If you'd like, I can mark this thread as solved and create a new thread for this new question. I just don't want to spam you guys with threads.

[pike]

Hi sirdeity
Have a look at the link
Microsoft Excel – Recording Macros
http://www.excel-it.com/excel_tutorials.htm
an new questions will need a new threads and titles


If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save