IFNA
Conditional Functions
Basic Description
The Excel IFNA function tests if an initial supplied value (or expression) evaluates to the Excel #N/A error. If so, the function returns a second supplied value; Otherwise the function returns the first supplied value.
The IFNA function is new to Excel 2013, so is not available in earlier versions of Excel.
The syntax of the function is:
IFNA( value, value_if_na )
Where the arguments are as follows :
| value | - | The value or expression to be tested |
| value_if_na | - | Alternative value or expression to be returned if the first supplied value evaluates to the #N/A error. |
IFNA Function Examples
The following spreadsheet shows two examples of the Excel IFNA function.
|
Formulas:
|
|||||||||||||||||||||||||||||||||||
|
Results:
|
|||||||||||||||||||||||||||||||||||