Creating Pixel-Perfect Reports > Getting Started with the Reports Tool in the Desktop Application > Building Report > Adding a New Sheet and Working with It > Working with Report Sheet Data > Using Formulas > Function Wizard > Logical Functions > IsNonText
The function wizard for the IsNonText function:
IsNonText(Value)
Value. Checked value.
It checks if the value is text.
It returns TRUE if the value is not text, otherwise it returns FALSE.
Numbers, empty cells, logical values, text, cell references, and formulas can be used as a parameter value.
Empty cells are not text ones.
| Formula | Result | Description |
| =IsNonText(C2:E9) | TRUE | The C2:E9 cell range does not contain only text values. |
See also:
Function Wizard │ Logical Functions
