ISERROR

ISERROR(value)

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

valueThe 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

 AB
1=ISERROR(B1) = True=10/0 = #DIV/0!
2=IF(ISERROR(B1),"error value",B1) = error value10
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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top