The Excel ERROR.TYPE function is a handy tool for identifying and categorizing errors in your Excel spreadsheets. It helps you quickly determine the type of error in a cell, making it easier to troubleshoot and correct issues in your data.
Syntax
ERROR.TYPE(error_value)
Arguments
| error_value | The value or reference to a cell containing an error that you want to identify. This is a required argument. |
How to use
The ERROR.TYPE function is straightforward to use. Simply provide the error value as an argument, and it will return a corresponding error type. Here are some examples to illustrate its usage:
Example 1: Suppose you have a cell (A1) with a #DIV/0! error, and you want to determine its error type. Use the following formula in another cell:
|
1 |
=ERROR.TYPE(A1) |
This formula will return 2, indicating that the error type is #DIV/0!.
Example 2: Let’s say you encounter a #VALUE! error in cell B2. To find its error type, use the formula:
|
1 |
=ERROR.TYPE(B2) |
The result will be 3, which signifies that the error type is #VALUE!.
Example 3 (Optional): In some cases, you might want to handle optional errors or values. If you’re not sure if a cell contains an error, you can use an IFERROR function in combination with ERROR.TYPE:
|
1 |
=IFERROR(ERROR.TYPE(C3), "No error found") |
This formula will first check if there is an error in cell C3. If an error is present, it will return the corresponding error type; otherwise, it will display “No error found.”
By using the ERROR.TYPE function, you can quickly identify and address errors in your Excel worksheets, making your data analysis and reporting more efficient.