Formulas > =ERROR.TYPE()

How To Use ERROR.TYPE() Function in Google Sheets


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

Common Questions about the ERROR.TYPE formula:
-What is the purpose of the ERROR.TYPE formula?
-How does the formula work?
-What values does it return?

How can the ERROR.TYPE formula be used appropriately?
The ERROR.TYPE formula can be used to check for errors in a specific cell and return a number corresponding to a certain type of error.

How can the ERROR.TYPE formula be commonly mistyped?
The most common way to mistype the ERROR.TYPE formula is to use an upper-case letter, i.e typing "Error.TYPE" instead of "ERROR.TYPE".  Also ERROR.TYP and EROR.TYPE.

What are some common ways the ERROR.TYPE formula is used inappropriately?
Using the ERROR.TYPE formula on a non-error cell, or using the formula in an inappropiate context, like trying to get the value of a cell, instead of the type of the error inside of it.

What are some common pitfalls when using the ERROR.TYPE formula?
The most common pitfall when using the ERROR.TYPE formula is forgetting to check if the formula is being used in the right context. Additionally, trying to use the formula with other data types like strings can lead to errors.

What are common mistakes when using the ERROR.TYPE Formula?
Common mistakes when using the ERROR.TYPE formula include using the wrong type of argument for the formula, mistyping the formula, or using the formula to try to get a value or a string.

What are common misconceptions people might have with the ERROR.TYPE Formula?
Common misconceptions people might have about the ERROR.TYPE formula are that the formula can be used to return the actual value of a cell or that it can be used with strings.

How To Actually Use ERROR.TYPE() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the ERROR.TYPE() formula:

DGET - Powerful VLOOKUP, INDEX-MATCH Replacement - Google Sheets Tutorial

Learn how to match data, join data from different tables & worksheets using DGET function in Google Sheets. Learn differences between DGET, VLOOKUP, INDEX/MATCH and why DGET might be an interesting or sometimes better alternative to VLOOKUP & INDEX/MATCH.

Generate a ERROR.TYPE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.