IFERROR
Description
If the specified value or expression results in an error, returns the value_if_error value; otherwise, returns the value.
Syntax
IFERROR(
value
,
value_if_error
)
- value: The value or expression to evaluate.
- value_if_error: The value to return if the initial value or expression results in an error.
Example
Formula | Result |
|---|---|
=IFERROR(12/0, 0) | 0 |
=IFERROR(1*5,0) | 5 |
=IFERROR(HYPERLINK(F1),"None") | Cell F1 displays the text None if an error occurs in the HYPERLINK
function. |