{"id":1879,"date":"2018-07-12T14:32:48","date_gmt":"2018-07-12T14:32:48","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1879"},"modified":"2023-11-02T19:38:35","modified_gmt":"2023-11-02T19:38:35","slug":"errortype","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/errortype\/","title":{"rendered":"ERROR.TYPE function"},"content":{"rendered":"\n
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.<\/p>\n\n\n\n
ERROR.TYPE(error_value)<\/strong><\/p>\n\n\n\n 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:<\/p>\n\n\n\n Example 1:<\/b> 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:<\/p>\n\n\n\n This formula will return 2, indicating that the error type is #DIV\/0!.<\/p>\n\n\n\n Example 2:<\/b> Let’s say you encounter a #VALUE! error in cell B2. To find its error type, use the formula:<\/p>\n\n\n\n The result will be 3, which signifies that the error type is #VALUE!.<\/p>\n\n\n\n Example 3 (Optional):<\/b> 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:<\/p>\n\n\n\n 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.”<\/p>\n\n\n\n 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.<\/p>\n","protected":false},"excerpt":{"rendered":" The Excel ERROR.TYPE function is a handy tool for identifying and categorizing errors in your Excel spreadsheets. It helps you quickly determine the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
error_value<\/b><\/td> The value or reference to a cell containing an error that you want to identify. This is a required argument.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=ERROR.TYPE(A1)<\/code><\/pre>\n\n\n\n
=ERROR.TYPE(B2)<\/code><\/pre>\n\n\n\n
=IFERROR(ERROR.TYPE(C3), \"No error found\")<\/code><\/pre>\n\n\n\n