ISNONTEXT Function
Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.
Syntax
ISNONTEXT(<value>)
Parameters
Term |
Definition |
|---|---|
value |
The value you want to check. |
Return Value
TRUE if the value is not text or blank; FALSE if the value is text.
Remarks
An empty string is considered text.
Example
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")