Author: Oscar Cronquist Article last updated on April 17, 2018

The IFNA function handles #N/A errors only, it returns a specific value if the formula returns a #N/A error.

Formula in cell D3:

=IFNA(B3, "Yes")

Excel Function Syntax

IFNA(value, value_if_na)


value Required. The value you want to check.
value_if_na Required. The value to return if the value argument returns #N/A.


Use the IFNA function instead of the IFERROR function to check for #N/A errors specifically. For example, VLOOKUP returns #N/A when it can't find the lookup value.

The IFERROR function checks for all error values which in most cases is not recommended. This makes it harder to spot a more serious error since all error values are handled.