Use Formulas in Table Cells
 
 
 

To use a cell from a different table in a formula

  1. Select the table cell where you want to place the formula by clicking inside it. The Table toolbar is displayed.
  2. On the Table toolbar, click Insert Formula Cell.

    The following prompt is displayed:

    Select table cell:

  3. Click inside the cell in the other table.

    The In-Place Text Editor opens and displays the cell address.

  4. Enter the rest of the formula.
  5. To save your changes and exit the editor, use one of the following methods:

    The cell displays the result of the calculation.

 Toolbar: Table
 Shortcut menu: Select and right-click a cell or range of cells. Click InsertFormulaCell.