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
Result:
