Functions
ISERROR
True if value is an error
Try it
When to use it
When should I use ISERROR?
Use ISERROR to test whether any formula result is an error of any kind — useful in conjunction with IF to substitute a fallback value whenever a calculation fails, including #N/A.
Used in
Syntax
ISERROR(value)