Google Sheets
IFERROR function in Google Sheets
Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.
=IFERROR(value, [value_if_error])IFERROR syntax and parameters
Two arguments, one required.
- valueanyRequired
The value to return if value itself is not an error.
- value_if_erroranyOptional
[ OPTIONAL - blank by default ] - The value the function returns if value is an error.
IFERROR examples
Formulas you'll actually reuse.
A lookup that says so instead of #N/A when the key is missing:
=IFERROR(VLOOKUP(F2, A2:D200, 4, FALSE), "Not found")Result
"Not found"A ratio that reads as zero when the divisor is blank (#DIV/0!):
=IFERROR(D2 / C2, 0)Result
0
IFERROR in Excel
Same name — your formula ports as-is.
Try IFERROR in the playground
Edit the example — nothing to install.
Preloaded with the IFERROR formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ANDReturns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.LogicalExcel
- FALSEReturns the logical value `FALSE`.LogicalExcel
- IFReturns one value if a logical expression is `TRUE` and another if it is `FALSE`.LogicalExcel
- IFNAEvaluates a value. If the value is an #N/A error, returns the specified value. .LogicalExcel
- IFSEvaluates multiple conditions and returns a value that corresponds to the first true condition.LogicalExcel
- LAMBDACreates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares.LogicalExcel