{"id":1281,"date":"2018-07-02T17:33:08","date_gmt":"2018-07-02T17:33:08","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1281"},"modified":"2023-11-03T10:04:15","modified_gmt":"2023-11-03T10:04:15","slug":"iserr","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/iserr\/","title":{"rendered":"ISERR function"},"content":{"rendered":"\n<p>The ISERR function in Excel is a logical function used to check if a given value is an error other than #N\/A. It returns TRUE if the value is any error except #N\/A, and FALSE if the value is not an error or is #N\/A. This function is useful for identifying and handling errors in your spreadsheet data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>ISERR(value)<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>value<\/strong><\/td><td>The value you want to check for errors.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>You can use the ISERR function to determine if a cell contains any error other than #N\/A. Here are some examples of how to use it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ISERR(A1)<\/code><\/pre>\n\n\n\n<p>This formula checks if the value in cell A1 is an error other than #N\/A and returns TRUE or FALSE accordingly.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ISERR(B2)<\/code><\/pre>\n\n\n\n<p>Similarly, this formula checks if the value in cell B2 is an error other than #N\/A and provides the result as TRUE or FALSE.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example<\/h2>\n\n\n\n<p>Here&#8217;s a practical example. Suppose you have a column of data where some cells may contain errors. You want to identify and mark those cells as errors. You can use conditional formatting and the ISERR function to achieve this.<\/p>\n\n\n\n<p>1. Select the range of cells you want to format.<\/p>\n\n\n\n<p>2. Go to the &#8220;Home&#8221; tab and click on &#8220;Conditional Formatting&#8221; in the &#8220;Styles&#8221; group.<\/p>\n\n\n\n<p>3. Choose &#8220;New Rule.&#8221;<\/p>\n\n\n\n<p>4. In the &#8220;New Formatting Rule&#8221; dialog, select &#8220;Use a formula to determine which cells to format.&#8221;<\/p>\n\n\n\n<p>5. Enter the formula <code>=ISERR(A1)<\/code> (assuming A1 is the first cell in your selected range).<\/p>\n\n\n\n<p>6. Click on the &#8220;Format&#8221; button to choose the formatting style you want for the error cells.<\/p>\n\n\n\n<p>7. Click &#8220;OK&#8221; to apply the formatting rule.<\/p>\n\n\n\n<p>Now, any cell in the selected range that contains an error other than #N\/A will be formatted according to your chosen style, making it easy to spot and address data issues.<\/p>\n\n\n\n<p>By using the ISERR function, you can efficiently handle and identify errors in your Excel spreadsheets, making your data analysis and reporting more robust.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The ISERR function in Excel is a logical function used to check if a given value is an error other than #N\/A. It&#8230;<\/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":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ISERR function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/iserr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ISERR function\" \/>\n<meta property=\"og:description\" content=\"The ISERR function in Excel is a logical function used to check if a given value is an error other than #N\/A. It...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/iserr\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T17:33:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T10:04:15+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\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\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/iserr\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/iserr\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"ISERR function\",\"datePublished\":\"2018-07-02T17:33:08+00:00\",\"dateModified\":\"2023-11-03T10:04:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/iserr\/\"},\"wordCount\":328,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/iserr\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/iserr\/\",\"name\":\"ISERR function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-02T17:33:08+00:00\",\"dateModified\":\"2023-11-03T10:04:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/iserr\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/iserr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/iserr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ISERR function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ISERR function","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:\/\/officetuts.net\/excel\/functions\/iserr\/","og_locale":"en_US","og_type":"article","og_title":"ISERR function","og_description":"The ISERR function in Excel is a logical function used to check if a given value is an error other than #N\/A. It...","og_url":"https:\/\/officetuts.net\/excel\/functions\/iserr\/","article_published_time":"2018-07-02T17:33:08+00:00","article_modified_time":"2023-11-03T10:04:15+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/iserr\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/iserr\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"ISERR function","datePublished":"2018-07-02T17:33:08+00:00","dateModified":"2023-11-03T10:04:15+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/iserr\/"},"wordCount":328,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/iserr\/","url":"https:\/\/officetuts.net\/excel\/functions\/iserr\/","name":"ISERR function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-02T17:33:08+00:00","dateModified":"2023-11-03T10:04:15+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/iserr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/iserr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/iserr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"ISERR function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1281"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1281"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1281\/revisions"}],"predecessor-version":[{"id":16484,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1281\/revisions\/16484"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}