IFERROR function in Excel

IFERROR returns a fallback when a formula errors.

Syntax

=IFERROR(value, value_if_error)

Argument	Required?	What it is
value	Required	The value, cell or formula to check.
value_if_error	Required	What to show instead if value is any error.

Type the formula yourself and get it graded instantly, no Excel needed.

IFERROR returns a fallback when a formula errors.

=IFERROR(value, value_if_error)

Argument	Required?	What it is
value	Required	The value, cell or formula to check.
value_if_error	Required	What to show instead if value is any error.

Type the formula yourself and get it graded instantly, no Excel needed.