ISERROR

ISERROR(value)

Returns the boolean True or False depending if the value is an error.

value

The value that you want to test.

REMARKS

* The "value" can refer to a value, text string, cell reference, formula or a named range.
* The following types of errors are identified: #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF! and #VALUE!.
* You can use the IFERROR function to return the value or something else if it evaluates to an error.
* You can use the IFNA function to return the value or something else if it evaluates to #N/A.
* You can use the ISBLANK function to return True or False depending if the value is blank.
* You can use the ISNA function to return True or False depending if the value is #N/A.
* You can use the ISERR function to return the boolean True or False depending if the value is an error (excluding #N/A).
* You can use the ISREF function to return True or False depending if the value is a cell reference.
* You can use the ERROR.TYPE function to return the number corresponding to a particular error value in a cell.
* The equivalent VBA function is VBA.ISERROR
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ISERROR(B1) = True	=10/0 = #DIV/0!
2	=ISERROR(#DIV/0!) = True	10
3	=ISERROR(#N/A) = True
4	=ISERROR(#NAME?) = True
5	=ISERROR(#NULL!) = True
6	=ISERROR(#NUM!) = True
7	=ISERROR(#REF!) = True
8	=ISERROR(#VALUE!) = True
9	=ISERROR(B2) = False
10	=ISERROR(50) = False
11	=ISERROR("") = False
12	=ISERROR("some text") = False
13	=ISERROR(invalid_namedrange) = True

1 - Does the formula in "B1" (which evaluates to #DIV/0!) get identified as an error.
2 - Does the formula in "B1" return an error. If it does return "error value" and if not then return the value.
3 - Does the formula in "B1" return an error. If it does return "error value" and if not then return the value.
4 - Does #DIV/0! get identified as an error.
5 - Does #N/A get identified as an error.
6 - Does #NAME? get identified as an error.
7 - Does #NULL! get identified as an error.
8 - Does #NUM! get identified as an error.
9 - Does #REF! get identified as an error.
10 - Does #VALUE! get identified as an error.
11 - Does the formula in cell "B2" get identified as an error.
12 - Does the numerical value 50 get identified as an error.
13 - Does a blank string get identified as an error.
14 - Does a text string get identified as an error.
15 - Does an invalid named range get identified as an error.