Beginner
Information
ISERROR
Returns TRUE if a value is any kind of error (#N/A, #VALUE!, #REF!, and others), and FALSE otherwise.
Compatibility: All Excel versions
Syntax
=ISERROR(value)
Example
=ISERROR(A1/B1)
When to Use It
Use ISERROR to check whether a formula produced an error, often combined with IF to show something more readable in its place.