Microsoft Office Tutorials and References
In Depth Information
Creating a megaformula basically involves copying formula text and pasting it into another formula. I start with
a relatively simple example. Examine the spreadsheet shown in Figure 21-1. This sheet uses formulas to calcu-
late mortgage loan information.
Figure 21-1: This spreadsheet uses multiple formulas to calculate mortgage loan information.
This workbook, named total interest.xlsx, is available at this topic's website.
The Result Cells section of the worksheet uses information entered into the Input Cells section and contains the
formulas shown in Table 21-1.
Table 21-1: Formulas Used to Calculate Total Interest
What It Does
Calculates the down payment amount
Calculates the loan amount
C12 =PMT(C7/12,C6,-C11) Calculates the monthly payment
Calculates the total payments