Microsoft Office Tutorials and References

In Depth Information

**Calculate Multiple Solutions to a Formula**

Chapter 5: Analyzing Excel Data

The Data Table dialog

box appears.

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

text box.

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.

●

6

7

Excel displays the results.

Try This!

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.