# Supported Formula Functions

> Functions for TableCellFormula formulas in TXTextControl tables: mathematical, statistical, logical, lookup and information functions after ISO/IEC 29500-1.

- **Product:** TX Text Control ActiveX
- **Section:** Documentation
- **Kind:** Topic
- **Path:** TX Text Control ActiveX > API Reference > Supported Formula Functions
- **266 words**
- **Web URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/
- **LLMs URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/llms.txt
- **LLMs-Full URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/llms-full.txt

---

A formula in a table cell of `TXTextControl`, set with the [`TableCellFormula`](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/tablecellformula-property/llms-full.txt) 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](https://docs.textcontrol.com/tx-text-control-activex/document-editor/tables/formulas/llms-full.txt). The pages below list the functions of each group with their arguments and results.

### Pages in This Section

- [Mathematical and Trigonometric](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/mathematical-trigonometric/llms-full.txt): arithmetic, rounding, logarithms, trigonometry and sums.
- [Statistical](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/statistical/llms-full.txt): averages, counts, maximums and minimums.
- [Logical](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/logical/llms-full.txt): AND, OR, NOT, IF, TRUE and FALSE.
- [Lookup and Reference](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/lookup-reference/llms-full.txt): cell addresses, rows, columns and choosing from a list.
- [Information](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/information/llms-full.txt): test the type and content of values and cells.

---

## In This Section

- [Information](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/information/llms-full.txt): ISBLANK, ISNUMBER, ISTEXT, ISEVEN, ISODD, ISREF, N, NA and TYPE for table cell formulas in TXTextControl: test what a value or table cell contains.
- [Logical](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/logical/llms-full.txt): IF, AND, OR, NOT, TRUE and FALSE for table cell formulas in TXTextControl: test conditions, combine logical values and return one of two results.
- [Lookup and Reference](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/lookup-reference/llms-full.txt): ADDRESS, CHOOSE, COLUMN, COLUMNS, ROW and ROWS for table cell formulas in TXTextControl: build cell addresses and count rows and columns of references.
- [Mathematical and Trigonometric](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/mathematical-trigonometric/llms-full.txt): SUM, PRODUCT, ROUND, MOD, POWER, SQRT, LOG, SIN, COS and other mathematical and trigonometric functions for table cell formulas in TXTextControl.
- [Statistical](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/statistical/llms-full.txt): AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MAXA, MIN and MINA for table cell formulas in TXTextControl, with the limitations of the counting functions.

---

## Nearby

- **Previous:** [Keyboard Assignment for Hyphens](https://docs.textcontrol.com/tx-text-control-activex/reference/assignments/hyphens/llms-full.txt)
- **Next:** [Mathematical and Trigonometric](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/mathematical-trigonometric/llms-full.txt)