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