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 |