IFNA Function in Excel: Syntax, Examples and Free Practice
IFNA is an Excel Logic function. Like IFERROR, but only catches #N/A errors specifically.
IFNA syntax
Arguments
value: The value to evaluatevalue_if_na: What to return if the formula results in #N/A
When to use IFNA
IFNA is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice IFNA online, free
Open the live Excel-style spreadsheet and try IFNA yourself. No Excel install or sign-up needed to start.
Practice IFNA now →Learn more
Read the tutorial: Fix #N/A, #VALUE! and #REF!.
More Logic functions
Frequently asked questions
What does the IFNA function do in Excel?
Like IFERROR, but only catches #N/A errors specifically.
What is the syntax of IFNA in Excel?
The syntax is =IFNA(value, value_if_na). value: The value to evaluate; value_if_na: What to return if the formula results in #N/A.
Where can I practice IFNA online for free?
Open the free live spreadsheet on Cellgrids and try IFNA yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts