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!")
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.