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.


Frequently Asked Questions

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.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV