Navigation:  Formula Reference > Spreadsheet Formula Functions >

IFERROR

Previous pageReturn to chapter overviewNext page

 

This function evaluates a formula and returns a value you provide if there is an error or the formula result.

Syntax

IFERROR(value,error)

Arguments

This function has these arguments:

Argument

Description

value

Value or expression to evaluate

error

Value to return if the formula returns an error

Remarks

The following error types are evaluated, #VALUE!, #REF!, #NUM!, #NAME?, #DIV/O, #N/A, or #NULL

Data Types

Accepts any type of formula for the value. Returns any data type.

Example

IFERROR(A3/A5,"dogs")

 

See Also

AND

FALSE