#1
|
|||
|
|||
How do cell events in the "Loan Amortization Schedule" template work?
I am trying to learn how Microsoft's "Loan Amortization Template" works in my Office 365 version of Excel.
If the user enters a number in the cell named LoanPeriod, or in the cell named PaymentsPerYear, the spreadsheet automatically recalculates the number of payment lines to display. How does that happen? I can find no VBA behind code for the spreadsheet. |
#2
|
|||
|
|||
Its all done with mirrors . no it's done with Excel formula's in each cell and this gives you the result.
|
#3
|
|||
|
|||
Er, I was looking for a little more detail. For example, if the user changes the Loan Period In Years from 1 to 12, with the payments per year already set to 12, then 28 lines for payments are added to the spreadsheet. Where's the formula for that? It's not in the cell for the Loan Period In Years.
|
#4
|
|||
|
|||
all the cells are prefilled, click on an empty one and you will see the formula in it. i didn't check to see how many lines are prefilled but expect it will be a lot.
|
#5
|
|||
|
|||
Quote:
Again, if I click in the cell for loan period in years, I see a number, not a formula. Also, it appears that no lines are prefilled. The number of prefilled lines is controlled by the loan period and payments per year. I have attempted to upload the workbook. I hope it made it. |
#6
|
|||
|
|||
Click on row 50, you WILL see the cell formula
|
#7
|
|||
|
|||
As TrevorC has said all formulas are there but with an IF that 'turns off' the formula if the payment number is exceeded.
the formulas run down to row 371 |
#8
|
|||
|
|||
Thanks for the backup, some ppl are hard convince
|
Tags |
events |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Daily Loan Tracking schedule | pranjal | Excel | 1 | 12-04-2014 11:57 AM |
Specifying "time of day" events | DavidHarris | Project | 3 | 05-26-2014 07:21 AM |
'Linking' entered information to other "cells" from an original "cell" in MS Word | Wade | Word | 6 | 09-03-2012 05:22 PM |
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? | Learner7 | Excel | 1 | 04-25-2011 04:39 AM |
Template "File In Use" when opening 2 documents based on the same template | wendt | Word | 5 | 12-15-2009 12:37 AM |