Microsoft Office Tutorials and References

In Depth Information

**Two-Way Table**

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.