Formulas and expressions
A field instruction can involve a calculation via a formula:
formula:expression
where expression can be an arbitrary complex arithmetic expression involving constants (§2.16.3.1), bookmarks that refer to expressions (§2.16.3.2), arithmetic and logical operators (§2.16.3.3), functions (§2.16.3.4), values of cells in a table (§2.16.3.5), and fields that result in a single value. expression can contain grouping parentheses to document the default precedence or to override it.
All arithmetic terms in an expression are real numbers. Infinities and NaN (Not-a-Number) are not supported.
example: : In the expression
1/3, although the operands appear to be integers, they are, in fact real numbers, and the result is 0.33.