IFNA
Returns a specified value if a formula evaluates to #N/A error; otherwise returns the formula result.
| Category | Lookup |
| Syntax | IFNA(value, value_if_na) |
Parameters
| Parameter | Required | Description |
|---|---|---|
value | Required | The expression to check for a #N/A error. |
value_if_na | Required | The value to return if the expression evaluates to #N/A. |
Example
IFNA(value, range, col)
Auto-generated from the EngCanvas function registry.