Skip to content
Google Sheets

ERROR.TYPE function in Google Sheets

Returns a number corresponding to the error value in a different cell.

=ERROR.TYPE(reference)

ERROR.TYPE syntax and parameters

One argument, one required.

  • referenceanyRequired

    The cell to find the error number for - you can also provide the error value directly.

ERROR.TYPE examples

Formulas you'll actually reuse.

  1. Which error a lookup cell holds — 7 is #N/A, 2 is #DIV/0!, 3 is #VALUE!:

    =ERROR.TYPE(F2)

    Result7

  2. A readable label for whatever went wrong in F2:

    =IF(ISERROR(F2), CHOOSE(ERROR.TYPE(F2), "Null", "Div by zero", "Value", "Ref", "Name", "Num", "Not found"), "OK")

    Result"Not found"

ERROR.TYPE in Excel

Same name — your formula ports as-is.

Try ERROR.TYPE in the playground

Edit the example — nothing to install.

Preloaded with the ERROR.TYPE formula from Example 1 — change anything and watch it respond.

Loading the editor…

ERROR.TYPE errors

What they mean — and the fixes.

  • #N/A

    The referenced cell holds no error at all — guard with ISERROR before calling ERROR.TYPE.

Related functions

More ways Google Sheets gets this done.