All functions / Logical

IFERROR

Returns a fallback value if a formula results in an error.

Syntax

=IFERROR(value, value_if_error)

Arguments

Example

=IFERROR(A2/B2, 0) → 0 instead of #DIV/0!

Practise it