deepcalc
DocsERROR.TYPE

ERROR.TYPE

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

Returns number corresponding to an error type.

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

Examples

=ERROR.TYPE(NA())
Result 7

Syntax

ERROR.TYPE(error_val)
error_val
any required

Errors

#N/A
=ERROR.TYPE(2)
CELLInformation about a cell's formatting, location or contents. 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. ISEMAILTrue when text looks like an email address.