# ERRORTYPE

Formulas / ERRORTYPE
Return a number representing an error value.
`ERRORTYPE(error_val)`
• error_val - the error value to find

## Examples

• `=ERROR.TYPE(A3)`

The function can be used to return the error type number associated with a cell. For example, if cell A3 returns the #DIV/0! error, the formula would return 3. This number can then be used to determine what other functions should be used.

• `=IF(ERROR.TYPE(A3)<3,CHOOSE(ERROR.TYPE(A3),"Ranges do not intersect","The divisor is zero"))`

The function can also be used to return text related to the error in a cell. In this example, the function returns the number 3 for the #DIV/0! error. This can then be used to display the text "The divisor is zero" in the cell.

## Summary

The ERROR.TYPE function in Excel 2003 returns a numeric code based on a specific error value. It takes one argument, error_val, which should be an error message like #VALUE!, #DIV/0!, #NAME!, etc.

• The ERROR.TYPE function takes one argument, error_val, which is expected to be a Sourcetable error, and returns a number that corresponds to a specific error code.

What is the Sourcetable ERROR.TYPE function?
The Sourcetable ERROR.TYPE function is used to return a number that corresponds to a specific error message. It takes one argument, error_value, which is expected to be an error like #VALUE!, #DIV/0!, #NAME!, etc.
What are the error codes for the ERROR.TYPE function?
• An error code of 1 is a #NULL! error
• An error code of 2 is a #DIV/0! error
• An error code of 3 is a #VALUE! error
• An error code of 4 is a #REF! error
• An error code of 5 is a #NAME? error
• An error code of 6 is a #NUM! error
• An error code of 7 is a #N/A error
• An error code of 8 is a #GETTING_DATA error
• An error code of 9 is a #SPILL! error
• An error code of 14 is a #CALC! error
How does the ERROR.TYPE function work?
The ERROR.TYPE function takes one argument, error_value, which is expected to be an error like #VALUE!, #DIV/0!, #NAME!, etc. It returns a number that corresponds to a specific error message. The error code is then used to test for specific types of errors.