IsNonText

Syntax

IsNonText(Value)

Parameters

Value. Checked value.

Description

It checks if the value is text.

Comments

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.

Example

Formula Result Description
=IsNonText(C2:E9) TRUE The C2:E9 cell range does not contain only text values.

See also:

Function Wizard │ Logical Functions