Please note javascript is required for full website functionality.


A to Z of Excel Functions: The IFNA Function

1 June 2020

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the IFNA function.

The IFNA function

The IFNA function returns the value you specify if a formula returns the #N/A error value; otherwise it returns the result of the formula.

IFNA has the following syntax:

IFNA(value, value_if_NA)

  • value: this is required and represents the argument that is checked for the #N/A error
  • value_if_NA: this is also required.  This is the value to return if the formula (value) evaluates to the #N/A error value.

It should be noted that:

  • if value or value_if_NA is an empty cell, IFNA treats the argument(s) as an empty string value ("")
  • if value is an array formula, IFNA returns an array of results for each cell in the range specified in value.

Please see my example below.

We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here.