Functions
IFERROR
Return alternate value on error
Try it
When to use it
When should I use IFERROR instead of IF?
Use IFERROR to catch and replace a formula that returns an error; use IF when you want to branch on a condition you define yourself.
Does IFERROR hide all errors?
Yes — it replaces any error (like #DIV/0! or #N/A) with the fallback you provide, so use it carefully or you may mask a real mistake.
Use cases
Return a friendly message when a lookup fails
Default to zero when a calculation errors
Used in
Syntax
IFERROR(value, value_if_error)Examples
=IFERROR(5,0) // => 5
=IFERROR(NA(),0) // => 0