ISNA Function in Excel: Syntax, Examples and Free Practice
ISNA is an Excel Information function. Checks whether a value is the #N/A error specifically.
ISNA syntax
=ISNA(value)
Arguments
value: The value to evaluate
When to use ISNA
ISNA is used to check the state or type of a cell before other formulas act on it.
Practice ISNA online, free
Open the live Excel-style spreadsheet and try ISNA yourself. No Excel install or sign-up needed to start.
Practice ISNA now →More Information functions
Frequently asked questions
What does the ISNA function do in Excel?
Checks whether a value is the #N/A error specifically.
What is the syntax of ISNA in Excel?
The syntax is =ISNA(value). value: The value to evaluate.
Where can I practice ISNA online for free?
Open the free live spreadsheet on Cellgrids and try ISNA 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