IFERROR function

Description

This IFERROR function return a custom result when a formula generates an error and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statement.

​

Objective

Specific predefined value for error condition.

​

Syntax

=IFERROR(value, value_if_error)

​

Arguments

value - value, reference or formula to detect error.

value_if_error - value of return if an error is found.

​

​