Returns TRUE if the value refers to an error value, and FALSE otherwise.
Syntax
Examples
Formula |
Result |
=ISERROR(A2) |
FALSE |
=ISERROR(A3) |
TRUE |
=ISERROR(A4) |
TRUE |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
ISBLANK
ISERR
ISEVEN
ISFORMULA
ISLEAPYEAR
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISREF
ISTEXT
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com