Create a one-variable data table

You must design one-variable data tables (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.) so that input values are listed either down a column (column-oriented) or across a row (row-oriented). Formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).) used in a one-variable data table must refer to an input cell (input cell: The cell in which each input value from a data table is substituted. Any cell on a worksheet can be the input cell. Although the input cell does not need to be part of the data table, the formulas in data tables must refer to the input cell.).

  1. Type the list of values you want to substitute in the input cell either down one column or across one row.
  2. Do one of the following:
    • If the data table is column-oriented, type the formula in the row above the first value and one cell to the right of the column of values. Type any additional formulas to the right of the first formula.
    • If the data table is row-oriented, type the formula in the column to the left of the first value and one cell below the row of values. Type any additional formulas below the first formula.
  3. Select the range of cells that contains the formulas and values you want to substitute.
  4. On the Data menu, click Table.
  5. Do one of the following:

ShowTip

You can add additional formulas to a one-variable data table.

 
 
Applies to:
Excel 2003