Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

ERROR.TYPE

Find an error code corresponding to the error value in Excel
Returns a number corresponding to an error type

Rational

Find an error code corresponding to the error value.

Description

The Excel ERROR.TYPE function returns an integer code of the corresponding error type or returns the #N/A if no error exists.

Syntax

=ERROR.TYPE (error_val)

Parameters

error_val – the error values in Microsoft Excel

Return Value

Corresponding code of error ranges from 1 to 8

Key Notes

In case of no error value in the reference cell, the return value is #N/A.

See below nine types of ERROR.TYPE code based on a reference in error_val:

Error_val returnERROR.TYPE codes
#NULL!1
#DIV/0!2
#VALUE!3
#REF!4
#NAME?5
#NUM!6
#N/A7
#GETTING_DATA8
Anything else#N/A

Keep Reading Similar Functions:

Check a cell for non-text value in Excel

ISNONTEXT

The ISNONTEXT function checks if a specified cell has non-text value and returns “TRUE” when a cell has a non-text, and “FALSE” it contains a text value.

Read More »
Check a cell for the text value in Excel

ISTEXT

The Excel ISTEXT function check if a specified cell has a value in text format and returns “TRUE” when a cell contains a text value, and “FALSE” if not.

Read More »
Find an error code corresponding to the error value in Excel

TYPE

The Excel TYPE function returns data type of reference cell or value of an argument. Example, =TYPE(“ABC”) return data type 2 (Text data format).

Read More »