# ISERROR

ISERROR(value)

Returns the value 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!.* The IFERROR function was added in Excel 2007 to easily accommodate the If-Then-Else condition. Examples 2 and 3.* 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 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.* This function will identify cells that contain a #N/A as an error (unlike the ISERR function).* The equivalent VBA function is VBA.ISERROR* For the Microsoft documentation refer to support.microsoft.com

 A B 1 =ISERROR(B1) = True =10/0 = #DIV/0! 2 =IF(ISERROR(B1),"error value",B1) = error value 10 3 =IFERROR(B1,"error value") = error value 4 =ISERROR(#DIV/0!) = True 5 =ISERROR(#N/A) = True 6 =ISERROR(#NAME?) = True 7 =ISERROR(#NULL!) = True 8 =ISERROR(#NUM!) = True 9 =ISERROR(#REF!) = True 10 =ISERROR(#VALUE!) = True 11 =ISERROR(B2) = False 12 =ISERROR(50) = False 13 =ISERROR("") = False 14 =ISERROR("some text") = False 15 =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.