deepcalc
DocsISERR

ISERR

View as markdown/docs/functions/iserr.md Ask Claude about this pageOpens Claude with this page's address

Returns TRUE if value is any error except #N/A.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Boolean

Examples

=ISERR(A1)
A
1 10
Result false

Syntax

ISERR(value)
value
any required
CELLInformation about a cell's formatting, location or contents. ERROR.TYPEReturns number corresponding to an error type. FORMULATEXTReturns formula as a text string. INFOInformation about the operating environment. ISBLANKReturns TRUE if value is blank. ISDATETrue when a value can be read as a date.