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

ISERROR

Check if cell refers to an error value in Excel
Returns TRUE if the value is any error value

Rational

Check if cell refers to an error value.

Description

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

Syntax

=ISERROR(value)

Parameters

value – Refer cell to check error.

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISERROR formula return TRUE for errors like #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! Including #N/A, unlike ISERR function.
  • The ISERROR 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 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 »
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 »