Spread Formula Reference
Formula Functions / Functions H to L / IFERROR
In This Topic
    IFERROR
    In This Topic

    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")

    Version Available

    This function is available in product version 5.0 or later.

    See Also

    AND | FALSE | Logical Functions