Embedded Files
Came across this scenario which I thought is a good illustration of a situation where array formulas could be useful ~ To derive the current balances of a list of mortgage loans given the following data.
Rather than using VBA to loop through the above to fill up a separate mortgage table, array formula involving PPMT function as per below screenshot would seem much more appropriate.
Download
Page updated
Google Sites
Report abuse