What is ERROR.TYPE function in Excel?
The ERROR.TYPE function is one of the Information functions of Excel.
It Returns a number matching an error value.
We can find this function in Information category of the insert function Tab.
How to use ERROR.TYPE function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select ERROR.TYPE function
6. Then select ok.
7. In the function arguments Tab you will see ERROR.TYPE function.
8. Error_val is the error value for which you want the identifying number, and can be an actual error value or a reference to a cell containing an error value.
9. You will see the results in formula result section.
Examples of ERROR.TYPE function in Excel
ERROR.TYPE related function
- Use ISERR function to Check whether a value is an error and returns TRUE or FALSE.
- Use ISERROR function to check whether a value is an error, and returns TRUE or FALSE.
- ISNA function
