Obviously you can make these settings what ever you desire for any application where you need to rapidly change 1 (or more) variable and see the results. Now you can scroll up and down and as you do the monthly loan payments changes by $10 a time, and the loan balance adjusts accordingly. And format the date cell with the date format you want. where cell address is the cell that is linked to the spin button. In the cell that holds your date place a formula like: 40000+cell address. Now right click the control and select format control. Link the forms spin button to a cell that is under (hidden by) the spin button. Then click and drag your mouse where you want it on your sheet. Lets say we want to add the ability to easily change the additional payments and see graphically what that will do to our loan timeline.įrom the Forms toolbar select the spin button. So now we have a nice looking chart that shows the closing balance of our mortgage over time. I then added a graph of the closing balance. Using the example of a mortgage, I used the mortgage template spreadsheet in Excel (under New Worksheet) to create a mortgage example. This is a cool function that can assist you to make easy to use adjustable tables and charts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |