# Information

> ISBLANK, ISNUMBER, ISTEXT, ISEVEN, ISODD, ISREF, N, NA and TYPE for table cell formulas in TXTextControl: test what a value or table cell contains.

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

---

Information functions test what a value or a table cell holds: whether it is empty, a number, text or a logical value, whether a number is even or odd and whether a value is a cell reference. Others convert a value to a number, return its type or return the error value #N/A.

Argument types, restrictions and return values of each function are defined in Office Open XML File Formats, ISO/IEC 29500-1, chapter 18.17.7 Predefined Function Definitions.

### Information Functions

| Function | Description |
|---|---|
| `ISBLANK(value)` | Determines if value refers to an empty cell. |
| `ISEVEN(value)` | Determines if value is an even number or refers to a cell containing an even number. |
| `ISLOGICAL(value)` | Determines if value contains a logical value or refers to a cell containing a logical value. |
| `ISNONTEXT(value)` | Determines if value does not contain text or does not refer to a cell containing text. An empty cell is not text. |
| `ISNUMBER(value)` | Determines if value contains a number or refers to a cell that contains a number. |
| `ISODD(value)` | Determines if value is an odd number or refers to a cell containing an odd number. |
| `ISREF(value)` | Determines if value is a cell reference. |
| `ISTEXT(value)` | Determines if value contains text or refers to a cell containing text. |
| `N(value)` | Converts value to a number or, if value is a reference to a single cell, converts the value of that cell to a number. |
| `NA()` | Gets the error value #N/A. (The error value #N/A can be used instead of a call to this function; the result is the same.) |
| `TYPE(value)` | Computes the type of value or, if value is a reference to a single cell, the type of the value in that cell. |

### Related Pages

- [Using Formulas in Table Cells](https://docs.textcontrol.com/tx-text-control-activex/document-editor/tables/formulas/llms-full.txt): calculate cell text with formulas.
- [Tables](https://docs.textcontrol.com/tx-text-control-activex/reference/categories/tables/llms-full.txt): `TableCellFormula` and the other members for tables and cells.
- [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.

---

## Nearby

- **Previous:** [Lookup and Reference](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/lookup-reference/llms-full.txt)