Supported Formula Functions

Topic

A formula in a table cell of TXTextControl, set with the TableCellFormula property, can call functions of five groups, listed on the pages below. Their definitions follow Office Open XML File Formats, ISO/IEC 29500-1, chapter 18.17.7 Predefined Function Definitions.

How a formula is built, with constants, operators and cell references, is explained in Using Formulas in Table Cells. The pages below list the functions of each group with their arguments and results.

Pages in This Section

Mathematical and Trigonometric: arithmetic, rounding, logarithms, trigonometry and sums.
Statistical: averages, counts, maximums and minimums.
Logical: AND, OR, NOT, IF, TRUE and FALSE.
Lookup and Reference: cell addresses, rows, columns and choosing from a list.
Information: test the type and content of values and cells.