IFNA Function Explained
The IFNA function in Microsoft Excel is used to return a value you specify if a formula returns the #N/A error. It takes two arguments: value and value_if_na. Value is the value to be tested and value_if_na is the value to be returned if value is #N/A.
IFNA Function Syntax
IFNA(value, value_if_na)
- value: The value to be tested for an error.
- value_if_na: The value to return if the expression resolves to an error.