All functions / Logical
IFERROR
Returns a fallback value if a formula results in an error.
Syntax
=IFERROR(value, value_if_error)
Arguments
value: The formula to try.value_if_error: What to return instead of an error.
Example
=IFERROR(A2/B2, 0) → 0 instead of #DIV/0!