IFNA
LogicalIFNA helps you perform conditional and boolean logic helpers for branching worksheet behavior.
Overview
Start with "=" then enter IFNA(value, value_if_na). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=IFNA(value, value_if_na)
2 required
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| value | Required | Single | Input argument used by this function. |
| value_if_na | Required | Single | Input argument used by this function. |
Example Inputs & Outputs
Formula
=IFNA(<value>, <value_if_na>)
Example Output
Boolean or conditional result
Replace placeholders with your worksheet values or ranges to compute a result.