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:
- 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.