The IFNA Excel formula is a Logical function that checks whether the reference contains an #N/A (not applicable) error. If the value is an #N/A error, the function returns a specified value; otherwise returns the value itself. In this guide, we’re going to show you how to use IFNA Excel function and also go over some tips and error handling methods. 


Supported versions

  • Excel 2013 and newer

IFNA Excel Syntax

IFNA(value, value_if_na)


Arguments

value

The value you want to test.

value_if_na

The value to be returned if the value argument is #N/A.



Example

=IFNA(F3,"beware the error!")
formula demonstrates a simple use case. The formula evaluates the value in cell F3, which has a formula that returns an #N/A error. Since the error is in cell F3, the formula returns the string value entered for the value_if_na argument. On the other hand, the formula in cell G5 returns the argument value, because F5 doesn't give an #N/A error.

IFNA Function

Download Workbook


Tips

  • You can use another formula or cell reference for value_if_na.
  • If value or value_if_na is an empty cell, IFNA treats it as an empty string value ("").
  • Use the IFERROR function for error handling.
  • The ISNA function returns a Boolean value if the value contains #N/A.