ISNONTEXT Function in Excel

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

ISNONTEXT Function in Excel 1

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

ISNONTEXT Function in Excel 2

previous-small ISNONTEXT Function in Excel                                                                                                                next_small ISNONTEXT Function in Excel