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

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 »