Use the Table Function


Tutorial Home >Software >Office >Microsoft Office 2000 Projects >How do I use the table function for mortgage analysis in Office 2000?
Tutorial Home >Software >Office >Microsoft Office 2000 Projects >Mortgage Analysis >Use the Table Function

  Step 1:  Select Cells

Open a Report
You will use the table function to calculate payments for each of the remaining options. The table function basically makes all the calculations for each combination of interest rate and mortgage amount at once. First, select cells B5 through F9. This range of cells contains the labels for the different mortgage costs and interest rates. The range also includes cell B5 which contains the PMT formula you want applied to each combination of mortgage amount and interest rate.
  Step 2:  Select the Table Function

Open a Report
Click Data on the menu bar, then click Table to open the Table dialog box.
  Step 3:  Complete the Table

Open a Report
Enter Mortgage for the Row Input cell and Interest for the Column Input cell as shown.
  Step 4:  Apply the Table Function

Open a Report
Click OK. You've got the required results, but they aren't formatted correctly.
  Step 5:  Apply Currency Style

Open a Report
Select cells C5 through F9 and then click the Currency Style button on the Formatting toolbar.
  Step 6:  View Results

Open a Report
Click away from the selected cells. Now you can see the monthly payment required for each of four mortgage amounts at each of four annual interest rates. For example, you would make a monthly payment of $1,226.47 on a $140,000 mortgage at 9%.