Rational
Check a cell for non-text value
Description
The Excel ISNONTEXT function checks if a specified cell has non-text value and returns “TRUE” when a cell has a non-text, and “FALSE” it contains a text value.
Syntax
= ISNONTEXT(value)
Parameters
value – Refer cell to check non-text value
Return Value
A Boolean value (TRUE or FALSE)
Key Notes
- The ISNONTEXT formula returns TRUE only if the value in the cell is non-text. The function will also return FALSE if a numerical value is stored in a text format.
- The formula returns TRUE if applied to a blank cell.
- The ISNONTEXT formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.
The ISNONTEXT function shows TRUE for any type of error like cell B12 contain #N/A formula =NA(B12) it return TRUE.
Keep Reading Similar Functions:
TYPE
The Excel TYPE function returns data type of reference cell or value of an argument. Example, =TYPE(“ABC”) return data type 2 (Text data format).
ISTEXT
The Excel ISTEXT function check if a specified cell has a value in text format and returns “TRUE” when a cell contains a text value, and “FALSE” if not.
ERROR.TYPE
The Excel ERROR.TYPE function returns an integer code of the corresponding error type or returns the #N/A if no error exists.