SheetFX
≡
<< Go back to all functions

ERROR.TYPE

The ERROR.TYPE function in Google Sheets returns a number corresponding to the error value in a different cell.

Function Syntax and Parameters

Syntax: ERROR.TYPE(reference)

Parameters:

  • reference: The cell reference that contains the error value.

Step-by-Step Tutorial

  1. Using ERROR.TYPE with a cell reference:
    • Example: If cell A1 contains an error value, =ERROR.TYPE(A1) will return the corresponding error number.

Use Cases and Scenarios

  1. Error Analysis: Identify the specific error type in a cell for further analysis.

Related Articles