Introduction
IFNA function in excel is a logical function. This function is used in case a formula produces an error. With this one can use a customized value if an error is displayed. It checks for #N/A errors. If no error is found IFNA returns the calculated value of the formula. It is a good alternative to complicated nested IF function.
Syntax
=IFNA(value,value_if_na)
Arguments
- Value- Value whose error has to be checked.
- Value_if_na- Custom value to be retrieved if error is found.
Keynotes
- It checks for #N/A errors, for other errors use IFERROR function.
- If value argument is left blank, it is used as a blank string and not as an error.
- If value_if_na argument is left blank, then if there is an error, it is displayed as a blank message.
- It can also be used as an array formula.
Examples
In the following example, IFNA function is used in cell G6 when the VLOOKUP function generated a #N/A error and 0 value is returned instead of the error. But IFNA function returns value 10 in column G5, since no error is found in the VLOOKUP function used here.