Search results
Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value.
People also ask
What is error type function in Excel?
How to test for specific types of errors in Excel?
What is error_Val in Excel?
What are error-related functions in Excel?
Nov 8, 2023 · The Excel ERROR.TYPE function returns a number that corresponds to an error type. As the name suggests, the function only works for errors. Upon finding anything other than errors, the function returns the #N/A (not available) error.
- Mehwish Javaid
The Excel ERROR.TYPE function returns a number that corresponds to a specific error value. You can use ERROR.TYPE to test for specific kinds of errors. If no error exists, ERROR.TYPE returns #N/A. See the table below for a key to the error codes returned by ERROR.TYPE.
- NAME? Error. Invalid name error, #NAME? , occurs when Excel does not recognize something, i.e., a function name, a misspelled function name or named range, cell reference not matching, etc.
- DIV/0! Error. #DIV/0! or divided by zero occurs when a value is divided by zero. Since any value divided by zero is undefined, Excel shows an error. In the image below, you can see no value in cell C9, meaning it contains 0.
- REF! Error. #REF! Error is a common error. Excel shows it if any cell reference is invalid. Like in the image below, I calculate the total cost by multiplying Units and Unit Cost values.
- NULL! Error. #NULL Error occurs if there is a typo in the formula, such as a space inserted instead of a comma or colon. For example, an asterisk sign was supposed to be between the cell references in the image.
What is the ERROR.TYPE Function? The ERROR.TYPE Function is categorized as an Excel Information function. The function returns a number that corresponds to a specific error value. If there is no error, it will return #N/A. While doing financial analysis, we can use this to test for a specific error value. Also, we can use ERROR.TYPE to display ...
The complete formula to be entered in cell B2 is =Error.Type (#REF!). The resulting value in cell B2 will be 4, indicating the #REF! Error, as depicted in the image below. Table of contents. What Is ERROR.TYPE Function in Excel? Syntax. How To Use ERROR.TYPE Function in Excel? Examples. Important Things To Note. Frequently Asked Questions ( F AQs)
Learn how Excel error types like #VALUE! and #NUM! work, how to catch them, and how to handle them using IFERROR, ISERROR, ISNA, ERROR.TYPE, and more...