Excel Error.type Function

This post will guide you how to use Excel ERROR.TYPE function with syntax and examples in Microsoft excel.

Description

The Excel ERROR.TYPE function returns a numeric value of one of the error type in EXCEL. If No error exists, the #N/A error will be returned.

The ERROR.TYPE function is a build-in function in Microsoft Excel and it is categorized as an Information Function.

The ERROR.TYPE function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the ERROR.TYPE function is as below:

= ERROR.TYPE (error_value)

Where the ERROR.TYPE function arguments are:
Error_value -This is a required argument.  The following error types can be used:

If error_val is ERROR.TYPE returns
#NULL! 1
#DIV/0! 2
#VALUE! 3
#REF! 4
#NAME? 5
#NUM! 6
#N/A 7
#GETTING_DATA 8
Anything else #N/A

Example

The below examples will show you how to use Excel ERROR.TYPE Function to return the numeric representation of one of the error type.

#1 = ERROR.TYPE (B1)

excel error type function example1

Note: The above excel formula will return the numeric representation of “#NUM!” error type.

Related Posts

Excel TYPE Function
excel type examples3

This post will guide you how to use Excel TYPE function with syntax and examples in Microsoft excel. Description The Excel TYPE function returns the type of a value. So you can use the TYPE function to return an integer ...

Excel N Function
excel n examples3

This post will guide you how to use Excel N function with syntax and examples in Microsoft excel. Description The Excel N function converts a value to a numeric value. And the N function can be used to convert the ...

Excel ISREF Function
excel isref examples1

This post will guide you how to use Excel ISREF function with syntax and examples in Microsoft excel. Description The Excel ISREF function used to check if a value is a valid reference. If so, returns TRUE; if the value ...

Excel ISNONTEXT Function
excel isnontext examples1

This post will guide you how to use Excel ISNONTEXT function with syntax and examples in Microsoft excel. Description The Excel ISNONTEXT function used to check if a value is text. If so, returns FALSE; if the text is not ...

Excel ISTEXT Function
excel istext examples1

This post will guide you how to use Excel ISTEXT function with syntax and examples in Microsoft excel. Description The Excel ISTEXT function used to check if a value is text. If so, returns TRUE; if the text is not ...

Excel ISNA Function
excel isna examples1

This post will guide you how to use Excel ISNA function with syntax and examples in Microsoft excel. Description The Excel ISNA function used to check if a cell contains the #N/A error, if so, returns TRUE; otherwise, the ISNA ...

Excel ISERR Function
excel iserr function example

This post will guide you how to use Excel ISERR function with syntax and examples in Microsoft excel. Description The Excel ISERR function returns TRUE if the value is any error value except #N/A. The ISERR function is a build-in ...

ISNUMBER Function in Excel
ISNUMBER Function Examples1

This post will guide you how to use ISNUMBER function with syntax and examples in Microsoft excel. Description The Excel ISNUMBER function returns TRUE if the value in a cell is a numeric value, otherwise it will return FALSE. so you can ...

Excel ISError Function

This post will guide you how to use Excel ISERROR function with syntax and examples in Microsoft excel. Description The Excel ISERROR function used to check for any error type that excel generates and it returns TRUE for any error ...

Excel ISBlank Function
excel isblank function example1

This post will guide you how to use Excel ISBLANK function with syntax and examples in Microsoft excel. Description The Excel ISBLANK function returns TRUE if the value is blank or null. The ISBLANK function is a build-in function in Microsoft ...

Sidebar