Add a formula to a one-variable data table

Microsoft Office Excel 2003

Show All Show All

Add a formula to a one-variable data table

Formulas used in a one-variable data table must refer to the same input cell.

  1. Do one of the following:
    • If the data table is column-oriented, type the new formula in a blank cell to the right of an existing formula in the top row of the table.
    • If the data table is row-oriented, type the new formula in a blank cell below an existing formula in the first column of the table.

  2. Select the data table, including the column or row that contains the new formula.
  3. On the Data menu, click Table.
  4. Do one of the following:
    • If the data table is column-oriented, type the cell reference for the input cell in the Column input cell box.
    • If the data table is row-oriented, type the cell reference for the input cell in the Row input cell box.