ISNONTEXT

Returns TRUE if the value is not text.

Sample Usage

ISNONTEXT(C5)

Syntax

ISNONTEXT(value)

• value - The value to be checked.
  

Examples

ISNONTEXT(C5) evaluates to FALSE if the cell C5 contains a text value. Else, it evaluates to TRUE.

Notes

• Where the argument is an empty string ISNONTEXT(""), the function evaluates to FALSE.
• Where the argument is a reference to an empty cell, the function evaluates to TRUE.
• Numeric values that are enclosed in double quotation marks are treated as text. So, while ISNONTEXT(12) evaluates to TRUE, ISNONTEXT("12") evaluates to FALSE.
• Non-printable characters and white spaces also count as text.