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 insert a Formula field in a table cell

1. Click inside the table cell.
2. On the Table toolbar, click Insert Field.
3. In the Field dialog box, Field Category list, select Objects.
4. In Field Names, select Formula.
5. To enter a formula, use any of the following methods one or more times:
   • Click Average, Sum, or Count. The Field dialog box closes temporarily. To specify a range, click inside the first and the last cell. The result is appended to the formula.
   • Click Cell. The Field dialog box closes temporarily. Select a cell in a table in the drawing. The cell address is appended to the formula.
6. (Optional) Select a format and a decimal separator.
7. Click OK.
8. 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 InsertFormula.