ERROR.TYPE

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

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

• Top 4 Basic Error Handling Functions Every Google Sheets User Should Know