Reference
No results for 'undefined'
    Powered by Algolia

    IFERROR

    Returns result if an expression does not return an error and another if it ends with Error.

    Syntax

    =IFERROR(expression, valueIfError)

    Parameters

    1. expression
      • Type: Any
      • Description: An expression to be evaluated.
    2. valueIfError
      • Type: Any
      • Description: The value the function returns if expression evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!

    Returns

    • Type: Any
    • Description: Returns value

    Example

    =IFERROR(A2/B1, "Division by zero")
    Contents