IFNA function

IFNA returns the value that you specify if the expression returns the #N/A error value. Otherwise, returns the result of the expression.

Syntax

IFNA(value,value_if_na)

  • value is the argument that is checked for the #N/A error.
  • value_if_na is the value to return if the expression evaluates to the #N/A error.
Note:
  • If value or value_if_error is an empty cell, IFNA treats it as an empty string value ("").
  • If value is an array formula, IFNA returns an array of results for each cell in the range.

Example

=IFNA(VLOOKUP("Formula",A5:B9,1),"not found")

IFNA checks the result of the VLOOKUP function. If Formula is not found in the lookup range, VLOOKUP returns the #N/A value. Then IFNA returns "Not found" in the cell, not the standard #N/A error value.