Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 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 »
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 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 »