IFERROR
TheIFERROR
formula is used to check whether a specified value results in an error or not. If the value results in an error, then it returns a userspecified value instead of the error. This function is commonly used to prevent errors from breaking a formula or to replace error messages with custom messages.
 How to use
IFERROR
formula?  Examples of using
IFERROR
formula IFERROR
formula not working? Similar formulas to
IFERROR
Usage
Use the IFERROR
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value (required):
The value that needs to be checked for errors.  value_if_error (optional):
An optional value to return if the first argument results in an error. If this argument is not provided, then the formula returns a blank cell instead of the error.
Examples
Here are a few example use cases that explain how to use theIFERROR
formula in Google Sheets.
Replacing #DIV/0! errors
The IFERROR
formula can be used to replace the #DIV/0!
error that occurs when a formula attempts to divide a number by zero. By wrapping the original formula with IFERROR
, you can specify a custom message or value to display instead of the error message.
Replacing #N/A errors
The IFERROR
formula can be used to replace the #N/A
error that occurs when a formula cannot find a specified value in a range. By wrapping the original formula with IFERROR
, you can specify a custom message or value to display instead of the error message.
Replacing #VALUE! errors
The IFERROR
formula can be used to replace the #VALUE!
error that occurs when a formula contains the wrong type of argument. By wrapping the original formula with IFERROR
, you can specify a custom message or value to display instead of the error message.
Common Mistakes
IFERROR
not working? Here are some common mistakes people make when using the IFERROR
Google Sheets Formula:
Not using the correct syntax
IFERROR requires two arguments separated by a comma. The first argument is the value you want to check for errors, and the second argument is the value to return if an error is found. Make sure you are using the correct syntax and separating the arguments with a comma.
Not specifying a value to return if an error is found
IFERROR requires two arguments. If the first argument returns an error, the second argument is returned instead. Make sure you are specifying a value to return if an error is found.
Misunderstanding the purpose of IFERROR
IFERROR is used to catch errors and return a specific value if an error is found. Make sure you understand the purpose of IFERROR and when it is appropriate to use.
Related Formulas
The following functions are similar to IFERROR
or are often used with it in a formula:

IF
The
IF
formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions. 
IFNA
The
IFNA
function checks if a value is an #N/A error and returns a specified value if it is. This is useful when you want to replace #N/A errors with a specific value. The function takes two arguments, the first argument is the value to check for #N/A error and the second argument is the value to return if the first argument is #N/A error. 
ISERROR
The
ISERROR
formula is used to check if a value contains an error. This formula returnsTRUE
if the value is an error, andFALSE
if it is not. This function is most commonly used in combination with other formulas that can return errors, to ensure that the resulting value is valid. 
ISNA
The
ISNA
function checks whether a value is #N/A. If the value is #N/A, the function returns TRUE; otherwise, it returns FALSE. This function is commonly used in combination with other functions that may return #N/A as a result.
Learn More
You can learn more about the IFERROR
Google Sheets function on Google Support.