by The Excel ISNONTEXT function returns TRUE for any non-text value, for example, a number, a date, a time, etc. The ISNONTEXT function also returns TRUE for blank cells, and for cells with formulas that return non-text results.
Syntax:= ISNONTEXT (value)
The ISNONTEXT function syntax has the following arguments:
- Value (required argument) – This is the expression or value that needs to be tested. It is generally provided as a cell address.
Example: Let’s look at some Excel ISNONTEXT function examples and explore how to use the ISNONTEXT function as a worksheet function in Microsoft Excel:
Syntax: =ISNONTEXT(A2)
Result:
Based on the Excel spreadsheet above, the following ISNONTEXT examples would return:
Syntax: =ISNONTEXT(A3)
Result: TRUE
Syntax: =ISNONTEXT(A4)
Result: TRUE
Syntax: =ISNONTEXT(A5)
Result: TRUE
Syntax: =ISNONTEXT(A6)
Result: TRUE
Syntax: =ISNONTEXT(A7)
Result: TRUE
Syntax: =ISNONTEXT(A8)
Result: FALSE
Syntax: =ISNFALSEONTEXT(A9)
Result: FALSE
Note:
Use the ISNONTEXT function to check if a value is not text. ISNA will return TRUE when value is a non-text value, for example, a number, a date, a time, etc. The ISNONTEXT function also returns TRUE for blank cells, and for cells with formulas that return non-text results.
ISNONTEXT is part of a group of functions called the IS functions that return the logical values TRUE or FALSE.
