IFNA
Description
If the specified value or expression results in an #N/A error, returns the
value_if_error value or run the alternative formula; otherwise, returns the
value.
Syntax
IFNA(
value
,
value_if_error
)
- value: The value or expression to evaluate.
- value_if_error: The value to return, or a formula to run, if the initial value or expression results in an #N/A error. If you want to run a formula, don't include the equals sign (=) at the beginning.
Example
Formula | Result |
|---|---|
=IFNA(1*5, "error") | 5 |
=IFNA(A1, "error") where A1 contains #N/A | error |