Article updated on April 17, 2018

The ISNONTEXT function returns TRUE if value is not text, also returns TRUE if cell is empty.

Formula in cell C3:

=ISNONTEXT(B3)

Excel Function Syntax

ISNONTEXT(value)

Arguments

value Required. The value you want to check if not text.

Comments

The ISNONTEXT function is very useful to identify error values in arrays. Most Excel functions return the same error value, however, this function returns FALSE if it encounters an error.