Syntax
=IFNA(value, value_if_na)Arguments
| Argument | Required | Description |
|---|---|---|
value | Required | The value or formula to check |
value_if_na | Required | The result to use instead of #N/A |
How to use IFNA
IFNA takes 2 required arguments. Type =IFNA( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=IFNA(NA(), "missing")Result =IFNA(1/0, 0)Result Related logical functions
- ANDTRUE when every argument is TRUE.
- FALSEThe logical value FALSE.
- IFReturns one value when a condition is TRUE and another when it is FALSE.
- IFERRORReturns a value of your choice when a formula gives an error, otherwise the formula result.
- IFSChecks conditions in order and returns the value of the first one that is TRUE.
- LAMBDACreates a reusable function with parameters. Call it right away, store it in a name or pass it to MAP, REDUCE and friends.
- LETNames the results of calculations so a formula can reuse them.
- NOTReverses a logical value.
- ORTRUE when any argument is TRUE.