• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Using Excel's Business-Model... > Setting Up a Two-Input Table

Setting Up a Two-Input Table

You also can set up data tables that take two input variables. This option enables you to see the effect on an investment's future value when you enter different values for, say, the annual deposit and the interest rate. The following steps show you how to set up a two-input data table:

1.
Enter one set of values in a column below the formula and the second set of values to the right of the formula in the same row, as shown in Figure 14.7.

Figure 14.7. Enter the two sets of values that you want to input into the formula.


2.
Select the range that includes the input values and the formula (B8:G15 in Figure 14.7).

3.
Choose Data, Table to display the Table dialog box.

4.
In the Row Input Cell text box, enter the cell address of the input cell that corresponds to the row values you entered (C2 in Figure 14.7—the Interest Rate variable).

5.
In the Column Input Cell text box, enter the cell address of the input cell you want to use for the column values (C4 in Figure 14.7—the Annual Deposit variable).

6.
Click OK. Excel runs through the various input combinations and then displays the results in the data table, as shown in Figure 14.8.



Figure 14.8. Excel substitutes each input value into the input cell and displays the results in the data table.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint