Use Formulas in Table Cells

Use Formulas in Table Cells

Use Formulas in Table Cells

 

Annotate Drawings > Tables > 

Use Formulas in Table Cells

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

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:
   • Click OK on the toolbar.
   • Click in the drawing outside the editor.
   • Press CTRL+ENTER.

   The cell displays the result of the calculation.

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