IFERROR

• 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:

=IFERROR(value, [value_if_error])

1. value (required):
   The value that needs to be checked for errors.
2. 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

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

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 returns TRUE if the value is an error, and FALSE 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.