ISNONTEXT function can be used to check for a value that is not text.
Purpose of Excel ISNONTEXT Function
The function helps to check if a cell contains text or not (is anything typed into a cell?).
Return value
This function returns TRUE if the value is not text.
This function returns FALSE if the value is text.
Syntax
=ISNONTEXT (value)
Arguments
| Arguments | Description | Remarks |
| value | The value to check | Mandatory |
Usage notes
- ISNONTEXT is part of a group of functions called the IS functions that return the logical values TRUE or FALSE.
Availability
since 2007 for windows,2011 for Mac