ISERR

ISERR(value)

Returns the boolean True or False depending if the value is an error (excluding #N/A).

value

The value that you want to test.

REMARKS

* This function is only available for backwards compatibility and should not be used.
* ISERROR was added in Excel 2003 to replace this function.
* This function will not identify cells that contain a #N/A as an error.
* The "value" can refer to a value, text string, cell reference, formula or a named range.
* You can use the IFERROR function to return the value or something else if it evaluates to an error.
* 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 ISREF function to return the boolean 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.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ISERR(#N/A) = False	=30/0 = #DIV/0!
2	=ISERR(#VALUE!) = True	10
3	=ISERR(#REF!) = True	20
4	=ISERR(#DIV/0!) = True	30
5	=ISERR(#NUM!) = True	40
6	=ISERR(#NAME?) = True
7	=ISERR(#NULL!) = True
8	=ISERR(B1) = True
9	=ISERR(B2:B5) = True
10	=ISERR(B1:B5) = True
11	=ISERR(50) = False
12	=ISERR("") = False
13	=ISERR("some text") = False
14	=ISERR(named_range) = True