Microsoft Office Tutorials and References

In Depth Information

**Performing What-If Analyses with Data Tables**

Figure 5-7:

A two-input

data table.

4.
On the Data tab, click the What-If Analysis button and choose Data

Table on the drop-down list.

The Data Table dialog box appears (refer to Figure 5-7).

5.
In the Row Input Cell text box, enter the address of the cell referred

to in the original formula where substitute values to the right of the

formula can be plugged in.

In Figure 5-7, for example, the rows to the right of the formula are for

length of loan substitute values. Therefore, I select cell B5, the cell

referred to in the original formula where the length of the loan is listed.

6.
In the Column Input Cell text box, enter the address of the cell

referred to in the original formula where substitute values below the

formula are.

In Figure 5-7, the substitute values below the formula cell are interest

rates. Therefore, I select cell B4, the cell referred to in the original

formula where the interest rate is entered.

7.
Click OK.

Excel performs the calculations and fills in the table.