The ISERROR function in Excel is used to check whether a value or expression results in an error. The syntax for the ISERROR function is:
Where value is the value or expression that you want to check for errors.
Here are some examples of how to use the ISERROR function in Excel:
- =ISERROR(A1/B1) – This formula will return TRUE if the result of dividing the value in cell A1 by the value in cell B1 results in an error, such as a #DIV/0! error.
- =ISERROR(VLOOKUP(A1, B1:C10, 2, FALSE)) – This formula will return TRUE if the VLOOKUP function returns an error, such as a #N/A error, when searching for the value in cell A1 in the range B1:C10.
- =IF(ISERROR(A1/B1), “Error”, A1/B1) – This formula will return the result of dividing the value in cell A1 by the value in cell B1, unless an error occurs, in which case it will return the text “Error”.
ISERROR Tips & Tricks
- The ISERROR function can be used in combination with other functions, such as IF, to handle errors in a specific way.
- The ISERROR function only checks for certain types of errors, such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, and #NAME?.
- The ISERROR function can be replaced with the ISNA function to specifically check for #N/A errors.
Common Mistakes When Using ISERROR
- Forgetting to include the value or expression to check for errors in the ISERROR function.
- Using the ISERROR function to check for errors that it does not recognize, such as #NULL! errors.
- Assuming that the ISERROR function will catch all errors, when it only catches certain types of errors.
Why Isn’t My ISERROR Working?
- Make sure that you have included the value or expression to check for errors in the ISERROR function.
- Check that the error you are trying to catch is one that the ISERROR function recognizes.
- Make sure that you are not using the ISERROR function to catch errors that it does not recognize.
ISERROR: Related Formulae
- ISNA: The ISNA function is similar to the ISERROR function, but specifically checks for #N/A errors.
- IFERROR: The IFERROR function is used to handle errors in a specific way, by returning a specified value if an error occurs.
- NA: The NA function returns the #N/A error value.
- ERROR.TYPE: The ERROR.TYPE function returns a number that corresponds to the type of error that occurred.
- IFNA: The IFNA function is similar to the IFERROR function, but specifically checks for #N/A errors.