NA Function in Excel: Syntax, Examples and Free Practice
NA is an Excel Information function. Returns the #N/A error value deliberately, often as a placeholder.
NA syntax
=NA()
When to use NA
NA is used to check the state or type of a cell before other formulas act on it.
Practice NA online, free
Open the live Excel-style spreadsheet and try NA yourself. No Excel install or sign-up needed to start.
Practice NA now →More Information functions
Frequently asked questions
What does the NA function do in Excel?
Returns the #N/A error value deliberately, often as a placeholder.
What is the syntax of NA in Excel?
The syntax is =NA().
Where can I practice NA online for free?
Open the free live spreadsheet on Cellgrids and try NA yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Information functions · Excel case studies · Excel tutorials · Excel shortcuts