Microsoft Office Tutorials and References
In Depth Information
FIGURE 17.7 Use B6, the Number of Years, for the Column Input
FIGURE 17.8 The Data Table for Changing the Number of Years
FIGURE 17.9 Entering the Parameters in a Two-Way Table
the number of years on the row side and the interest rate on the column side; and
observe their impact on the monthly payments.
To set up the table, list the rates (on the column side) and the number of years (on
the row) while the payment is at the intersection of the two (top left cell of the table.)
In cell E20 I have
Payment, and the value $564.05 is displayed. See Figure 17.9.