Export (0) Print
Expand All

ISNONTEXT Function

Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.

ISNONTEXT(<value>)

Term

Definition

value

The value you want to check.

TRUE if the value is not text or blank; FALSE if the value is text.

An empty string is considered text.

The following examples show the behavior of the ISNONTEXT function.

//RETURNS: Is Non-Text
=IF(ISNONTEXT(1), "Is Non-Text", "Is Text")

//RETURNS: Is Non-Text
=IF(ISNONTEXT(BLANK()), "Is Non-Text", "Is Text")

//RETURNS: Is Text
=IF(ISNONTEXT(""), "Is Non-Text", "Is Text")
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft