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.
Search JabSto ::




Custom Search