Handle Errors using IFERROR

Replace #DIV/0! and #N/A with friendly results.

You will learn to

• Recognise #DIV/0!
• Wrap a formula in IFERROR

How it works

IFERROR(value, value_if_error) returns the formula result, or a fallback if the formula errors: =IFERROR(B3/C3,0) shows 0 instead of #DIV/0!.

=IFERROR(B3/C3,0)