ISNA

Check a cell for #N/A error in Excel
Returns TRUE if the value is the #N/A error value

Rational

Check a cell for #N/A error.

Description

The Excel ISNA function check if a specified cell has #N/A error and returns “TRUE” when a cell has a #N/A error, and “FALSE” when a cell does not have a #N/A error.

Syntax

=ISNA(value)

Parameters

value – Refer cell to check #N/A error

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISNA formula returns TRUE only if it’s #N/A.
  • The ISNA formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

Keep Reading Similar Functions:

Check if cell refers to any error value except #N/A in Excel

ISERR

The ISERR function checks if a specified cell has error value ‘except #N/A’ and returns “TRUE” only if a cell has an error. For example: “=ISERR(#DIV/0!)” return TRUE.

Read More »
Returns #N/A error to specific cell in Excel

NA

The NA function returns with #N/A error. A #N/A error means “no value is available”, used to highlight empty cells or any missing information of data set.

Read More »
Check if cell refers to an error value in Excel

ISERROR

The Excel ISERROR function check if a specified cell has error value and returns “TRUE” when a cell has an error, and “FALSE” it does not.

Read More »