ISNONTEXT

  • Updated

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.