IFERROR
Returns specified ErrorValue, if given value represents an error. If not, this function simply returns given value.
Syntax
=IFERROR(Value, ErrorValue)
Arguments
| Name | Type | Description |
|---|---|---|
| Value | Value | Value to check against each defined error values. |
| ErrorValue | Value | The value to return, if first value returns an error. |
Return
| Type | Description |
|---|---|
| Value | ErrorValue, if error occurs, otherwise the Value. |
Examples
| Formula | Result | Comment |
|---|---|---|
| "Warning" | As the Value leads to a DIV/0 error, the text "Warning" is displayed. |