ISERR

Check if cell refers to any error value except #N/A in Excel
Returns TRUE if the value is any error value except #N/A

Rational

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

Description

The Excel ISERR function check if a specified cell has error value except #N/A and returns “TRUE” when a cell has an error, and “FALSE” when a cell does not have an error. For example: “=ISERR(#DIV/0!)” return TRUE.

Syntax

= ISERR(value)

Parameters

value – Refer a cell to check error

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISERR formula return TRUE for errors like #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! but false if the error value is #N/A.
  • If a user wants to find any error value including #N/A, appropriate Excel function is ISERROR.
  • The ISERR formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

Keep Reading Similar Functions:

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 »
Check a cell for #N/A error in Excel

ISNA

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

Read More »