17.16.3 Formulas and expressions
17.16.3 Formulas and expressions
A field instruction can involve a calculation via a formula, which is simply an expression that is an arbitrary complex arithmetic expression involving constants (17.16.3.1), bookmarks that refer to expressions (17.16.3.2), arithmetic and logical operators (17.16.3.3), functions (17.16.3.4), values of cells in a table (17.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. end example]
Subsections
Last updated on