ISNONTEXT Function in Excel tests if a supplied value has text. If the supplied value has text then ISNONTEXT Function returns FALSE, if not the function returns TRUE.
Syntax of ISNONTEXT Function in Excel:
ISNONTEXT(value)
Where value argument is the value or expression to be tested.
Example of ISNONTEXT Function in Excel:
Formula
- The above example takes up simple values, Expressions and cell reference as input and returns TRUE only if the resultant value does not have text, otherwise the function returns FALSE