Hi,
I have been using a spreadsheet with absolute cell referencing. The way the sheet works is:
1.) Input account value in the first cell (A1)
2.) In the second cell (A2) enter a compounding formula. Then absolute reference the Rate and copy and past. This way I can show a table of how an account compounds. I attached a simple example.
What I want to do is to use an input form. That looks like this
Account value
Rate
Year
I often have to change the rate or the number of years and I just want to be able to make the changes in one cell. Right now I have to make the change and then copy if down.
Thanks,
Denny12
Bookmarks