How to use Excel IFNA function

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.

Leave a Comment