ISNONTEXT

Check a cell for non-text value in Excel
Returns TRUE if the value is not text

Rational

Check a cell for non-text value

Description

The Excel ISNONTEXT function checks if a specified cell has non-text value and returns “TRUE” when a cell has a non-text, and “FALSE” it contains a text value.

Syntax

= ISNONTEXT(value)

Parameters

value – Refer cell to check non-text value

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISNONTEXT formula returns TRUE only if the value in the cell is non-text. The function will also return FALSE if a numerical value is stored in a text format.
  • The formula returns TRUE if applied to a blank cell.
  • The ISNONTEXT formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

The ISNONTEXT function shows TRUE for any type of error like cell B12 contain #N/A  formula =NA(B12) it return TRUE.

 

Keep Reading Similar Functions:

Find an error code corresponding to the error value in Excel

TYPE

The Excel TYPE function returns data type of reference cell or value of an argument. Example, =TYPE(“ABC”) return data type 2 (Text data format).

Read More »
Check a cell for the text value in Excel

ISTEXT

The Excel ISTEXT function check if a specified cell has a value in text format and returns “TRUE” when a cell contains a text value, and “FALSE” if not.

Read More »
Find an error code corresponding to the error value in Excel

ERROR.TYPE

The Excel ERROR.TYPE function returns an integer code of the corresponding error type or returns the #N/A if no error exists.

Read More »