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 manually enter a formula in a table cell

1. Double-click inside a table cell.

   The In-place Text Editor opens.

2. Enter a formula (a function or an arithmetic expression), as in the following examples:
   • =sum(a1:a25,b1). Sums the values in the first 25 rows of column A and the first row in column B.
   • =average(a100:d100). Calculates the average of the values in the first 4 columns in row 100.
   • =count(a1:m500). Displays the total number of cells in column A through column M in rows 1 through 100.
   • =(a6+d6)/e1. Adds the values in A6 and D6 and divides the total by the value in E1.

     Use a colon to define a range of cells and a comma for individual cells. A formula must start with an equal sign (=) and can contain any of the following signs: plus (+), minus (-), times (*), divided by (/), exponent (^), and parentheses ().

3. 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 InsertFormulaEquation.