Cellgrids Cellgrids
Home › Excel formulas › Information › ERROR.TYPE

ERROR.TYPE Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

ERROR.TYPE is an Excel Information function. Returns a number matching a specific error type.

ERROR.TYPE syntax

=ERROR.TYPE(error_val)

Arguments

When to use ERROR.TYPE

ERROR.TYPE is used to check the state or type of a cell before other formulas act on it.

Practice ERROR.TYPE online, free

Open the live Excel-style spreadsheet and try ERROR.TYPE yourself. No Excel install or sign-up needed to start.

Practice ERROR.TYPE now →

More Information functions

Frequently asked questions

What does the ERROR.TYPE function do in Excel?

Returns a number matching a specific error type.

What is the syntax of ERROR.TYPE in Excel?

The syntax is =ERROR.TYPE(error_val). error_val: The error value to identify.

Where can I practice ERROR.TYPE online for free?

Open the free live spreadsheet on Cellgrids and try ERROR.TYPE yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Information functions · Excel case studies · Excel tutorials · Excel shortcuts