How to use ISNONTEXT Function in Excel

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:

ISNONTEXT Function - How to use ISNONTEXT Function in Excel

Syntax:  =ISNONTEXT(A2)

Result:

ISNONTEXT Function in Excel - How to use ISNONTEXT Function in Excel

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.

Add a Comment

Your email address will not be published. Required fields are marked *