Microsoft Office Tutorials and References
In Depth Information
Calculate Multiple Solutions to a Formula
Chapter 5: Analyzing Excel Data
The Data Table dialog
6 Specify the formula cell
you want to use as the
data table’s input cell.
If the input values are in
a column, you can enter
the input cell’s address in
the Column Input Cell
If you entered the input
values in a row, you can
enter the input cell’s
address in the Row Input
Cell text box.
7 Click OK.
Excel displays the results.
The worksheet model shown in this section is an example of a one-input data table, as
you are only varying one of the formula’s input cells. However, Excel also enables you to
set up a two-input data table that varies two formula inputs at the same time. For
example, in the loan payment worksheet, you could set up a two-input data table that
varies the interest rate and the term.
To set up a two-input data table, you must set up two ranges of input cells. One range
must appear in a column directly below the formula, and the other range must appear in
a row directly to the right of the formula. Follow steps 2 to 5 to open the Data Table
dialog box, specify both the Row Input Cell and the Column Input Cell, and then click OK.