Using Formulas in Table Cells

In tables, you can use formulas in cells that are calculated based on the values from other cells.

A formula is an expression that calculates a value. If the formula returns an error, the cell displays "####".

Use the following functions in formulas:
  • Sum. Calculates the sum of the values from the defined cells.
  • Average. Calculates the average of the values from the defined cells.
  • Count. Counts the number of defined cells.

A formula must always start with the equal sign (=) and can contain the following signs:

Signs Description
+ Plus
- Minus
* Times
/ Divided by
^ Exponent
() Parentheses