Microsoft Office Tutorials and References
In Depth Information
Figure 13-4: The layout for a one-way data table.
Figure 13-5 shows a one-way data table (in D2:G9) that displays three calculations (payment amount, total pay-
ments, and total interest) for a loan, using eight interest rates ranging from 6.75% to 8.50%. In this example, the
input cell is cell B2. Note that the range E1:G1 is not part of the data table. These cells contain descriptive la-
Figure 13-5: Using a one-way data table to display three loan calculations for various interest rates.