Iferror

The formula checks whether the specified value or formula returns an error. If no error occurs, it returns the result. If an error occurs, it returns the specified replacement value

Syntax	Description
IFERROR(value,replacement)	Returns the result if no error occurs. If an error occurs, it returns the specified replacement value.

IFERROR(value,replacement)

The formula checks whether the specified value or formula returns an error. If no error occurs, it returns the result. If an error occurs, it returns the specified replacement value.

The checked value and the replacement value must be of the same type.

Syntax: iferror(value,replacement)

Name	Description
value	type: Any | The value or formula that is checked for an error
replacement	type: Any | The value returned if an error occurs.

Returns	Description
Any	The result of the specified value or formula, or the replacement value if an error occurs.

Examples:

=iferror(nth(A1:A3,5),'wrong_value')
=iferror(B2,0)

Error examples:

=sqrt(-4)
=date(2011,03,43)
=left(text,-2)
=nth(A1:A3,5)