ERRORTYPE
Formulas / ERRORTYPEReturn 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.
Need help with Formulas?
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.
Frequently Asked Questions
What is the Sourcetable ERROR.TYPE function?
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?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.