Detecting Problems With ISERROR
Test whether a cell contains an error before acting on it.
Testing for Errors
Sometimes you do not want to replace an error, you want to ask whether one exists and then decide what to do.
The ISERROR function does exactly that. It looks at a cell or formula and returns TRUE if the result is an error and FALSE if it is fine.
This lets you build your own custom handling, count errors, or flag problem rows. In this lesson you will learn ISERROR and its relatives.
The ISERROR Syntax
ISERROR takes a single argument, the value or formula to test:
=ISERROR(value)
It returns the logical value TRUE when the value is any error, and FALSE otherwise. It never shows the error itself, only a clean true or false answer.
On its own that is just information. Its real power comes when you pair it with IF.
=ISERROR(A2/B2)All lessons in this course
- Understanding Error Types
- Catching Errors With IFERROR
- Targeting Missing Lookups With IFNA
- Detecting Problems With ISERROR