{"id":169,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/error-type\/"},"modified":"2021-02-13T11:33:52","modified_gmt":"2021-02-13T11:33:52","slug":"error-type","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/error-type\/","title":{"rendered":"ERROR.TYPE"},"content":{"rendered":"

Welcome to our comprehensive guide on the ERROR.TYPE<\/strong> function in Microsoft Excel and Google Sheets. This function is invaluable for identifying the types of errors within a cell, enabling you to diagnose and address issues more effectively in your spreadsheets.<\/p>\n

Understanding the ERROR.TYPE Function<\/h2>\n

The ERROR.TYPE<\/strong> function provides a way to ascertain the type of error in a cell. It returns a numerical value each corresponding to a different type of error. This is particularly useful when managing complex formulas or handling large datasets.<\/p>\n

Syntax<\/h2>\n

The syntax for the ERROR.TYPE<\/strong> function is consistent across both Microsoft Excel and Google Sheets:<\/p>\n

ERROR.TYPE(error_val)<\/code><\/pre>\n
    \n
  • error_val<\/code>: This argument is the error value or a reference to the cell that contains the error you need to identify.<\/li>\n<\/ul>\n
    Examples of Using the ERROR.TYPE Function<\/h2>\n
    Below are scenarios demonstrating the application of the ERROR.TYPE<\/strong> function:<\/p>\n
    Example 1: Identifying the Error Type<\/h3>\n
    In this example, cell A1<\/code> contains a formula that results in a #DIV\/0! error. We will deploy the ERROR.TYPE<\/strong> function to pinpoint the error type.<\/p>\n\n\n\n
    Cell A1<\/th>\nFormula<\/th>\n<\/tr>\n
    #DIV\/0!<\/td>\n=1\/0<\/td>\n<\/tr>\n<\/table>\n
    Applying the ERROR.TYPE<\/strong> function:<\/p>\n
    =ERROR.TYPE(A1)<\/code><\/pre>\n
    This formula returns 2, indicating a #DIV\/0! error.<\/p>\n
    Example 2: Handling Errors in IF Statements<\/h3>\n
    You may also use the ERROR.TYPE<\/strong> function to integrate error handling into your formulas. Consider the following usage within an IF<\/code> statement:<\/p>\n
    =IF(ERROR.TYPE(A1) = 2, \"Division by zero error\", \"No error\")<\/code><\/pre>\n
    In this scenario, if cell A1 contains a #DIV\/0! error, the formula will display “Division by zero error”; otherwise, it will indicate “No error”.<\/p>\n
    Summary<\/h2>\n
    In summary, the ERROR.TYPE<\/strong> function is an essential tool for pinpointing error types within your Excel or Google Sheets spreadsheets. By utilizing this function, you can enhance error management and boost the precision of your data analysis and computations.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns a number corresponding to an error type<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[207],"tags":[],"class_list":["post-169","post","type-post","status-publish","format-standard","hentry","category-information"],"acf":[],"yoast_head":"\nExcel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel ERROR.TYPE function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/error-type\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel ERROR.TYPE function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/error-type\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:33:52+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/error-type\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/error-type\/\",\"name\":\"Excel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:33:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel ERROR.TYPE function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/error-type\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/error-type\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/error-type\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Information\",\"item\":\"https:\/\/functiontranslator.com\/en\/information\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ERROR.TYPE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel ERROR.TYPE function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/error-type\/","og_locale":"en_US","og_type":"article","og_title":"Excel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel ERROR.TYPE function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/error-type\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:33:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/error-type\/","url":"https:\/\/functiontranslator.com\/en\/error-type\/","name":"Excel ERROR.TYPE Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:33:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel ERROR.TYPE function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/error-type\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/error-type\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/error-type\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Information","item":"https:\/\/functiontranslator.com\/en\/information\/"},{"@type":"ListItem","position":3,"name":"ERROR.TYPE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"predecessor-version":[{"id":3060,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/169\/revisions\/3060"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}