IFERROR Function in Google Sheets

Syntax

IFERROR(value, [value_if_error])

Description

Returns the first argument if it is not an error value, otherwise returns the second argument.

Tips & Best Practices

Essential for handling #N/A, #DIV/0!, #VALUE! errors. Use "" for blank on error.

Example

=IFERROR(...)

The IFERROR function belongs to the Logical category of Google Sheets functions.

Related Functions

• IF — Returns one value if a logical expression is TRUE and another if FALSE....
• IFS — Evaluates multiple conditions and returns the value for the first TRUE condition...
• IFNA — Evaluates a value. If the value is an #N/A error, returns the specified value....
• AND — Returns TRUE if all arguments are TRUE....
• OR — Returns TRUE if any argument is TRUE....
• NOT — Returns the opposite of a logical value....

Need Help with IFERROR?

If you're struggling with IFERROR or need a custom formula built for your business, our Google Sheets experts can help. Get a free quote →