{"id":323126,"date":"2021-08-12T18:00:32","date_gmt":"2021-08-12T15:00:32","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-hide-errors-in-google-sheets\/"},"modified":"2021-08-12T18:00:32","modified_gmt":"2021-08-12T15:00:32","slug":"how-to-hide-errors-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-hide-errors-in-google-sheets\/","title":{"rendered":"#How to Hide Errors in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a40dad5b4efe\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a40dad5b4efe\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-hide-errors-in-google-sheets\/#Hiding_Error_Messages_in_Google_Sheets_Using_IFERROR\" >Hiding Error Messages in Google Sheets Using IFERROR<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-hide-errors-in-google-sheets\/#How_to_Use_an_IFERROR_Formula_in_Google_Sheets\" >How to Use an IFERROR Formula in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Hide Errors in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-741481\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The Google Sheets logo.\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you break a formula in Google Sheets, an error message will <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ear. You might prefer to hide these error messages to get a clean spreadsheet, especially if the overall data isn\u2019t affected, using the IFERROR function. Here\u2019s how.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Hiding_Error_Messages_in_Google_Sheets_Using_IFERROR\"><\/span>Hiding Error Messages in Google Sheets Using IFERROR<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The IFERROR function checks whether a formula that you\u2019re using results in an error. If it does, IFERROR allows you to return an alternative message or, if you\u2019d prefer, no message at all. This hides any potential error messages that might appear when you\u2019re performing calculations in Google Sheets.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741492\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Example-Google-Sheets-Errors.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An example of various Google Sheets formula errors.\" width=\"355\" height=\"214\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>There are a number of errors that can appear in Google Sheets that IFERROR can handle. For example, if you attempt to apply a mathematical function to a cell containing text (eg. <code>=C2*B2<\/code>, where <code>B2<\/code> contains text), Google Sheets will display a \u201c#VALUE\u201d error message.<\/p>\n<p>No spreadsheet is perfect, so error messages might not necessarily indicate a problem, especially if you\u2019re performing calculations on a data set that combines text and data. If you want to hide these messages completely, you\u2019ll need to nest (combine) your initial formulas within an IFERROR formula.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Restrict Data in Google Sheets with Data Validation<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Use_an_IFERROR_Formula_in_Google_Sheets\"><\/span>How to Use an IFERROR Formula in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>IFERROR is a simple function with only two arguments. The syntax of a formula containing IFERROR is a little like this:<\/p>\n<pre>=IFERROR(A2,\"Message\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741498\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/IFError-Example-Cell-Reference.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An example of an IFERROR formula in Google Sheets using a reference to another cell.\" width=\"546\" height=\"183\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The first argument is the formula that IFERROR is checking for errors. As the example above shows, this can be used to refer to other cells (cell A2 in this example) to hide formula error messages that appear elsewhere.<\/p>\n<p>These formulas can also be nested into an IFERROR formula directly. For example:<\/p>\n<pre>=IFERROR(0\/0, \"This formula has an error!\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741501\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/IFError-Example-Nested.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An example of an IFERROR formula in Google Sheets with a nested function.\" width=\"656\" height=\"184\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The second argument in an IFERROR formula is the custom error message that replaces Google Sheets\u2019 own message. For example, the illustration above shows that dividing zero by zero isn\u2019t possible. Rather than display Google\u2019s error message (#DIV\/0!), a custom error message appears.<\/p>\n<p>If you\u2019d prefer to have no error message, you can use a blank text string as your second argument. For example:<\/p>\n<pre>=IFERROR(0\/0,\"\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-741511 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/IFError-Example-No-Message.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An example of an IFERROR formula in Google Sheets, showing an empty error message using an empty text string.\" width=\"431\" height=\"157\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Rather than showing an error, the empty text string is \u201cdisplayed\u201d\u2014but, as this isn\u2019t visible, the cell appears empty. Unlike Excel\u2019s own IFERROR formula, IFERROR in Google Sheets will also hide error indicators\u2014the little red arrows that appear above cells to warn you of an error.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741513\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Formula-Error-Indicator.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An example of a Google Sheets formula error indicator, successfully hidden by an IFERROR formula.\" width=\"424\" height=\"197\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The IFERROR function won\u2019t fix problems with your calculations, but if you need to clean up your spreadsheet and don\u2019t mind missing a few error messages, IFERROR is the best way to achieve that in Google Sheets.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Hide Error Values and Indicators in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/741479\/how-to-hide-errors-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Hide Errors in Google Sheets&#8221; If you break a formula in Google Sheets, an error message will appear. You might prefer to hide these error messages to get a clean spreadsheet, especially if the overall data isn\u2019t affected, using the IFERROR function. Here\u2019s how. Hiding Error Messages in Google Sheets Using IFERROR The&#8230;<\/p>\n","protected":false},"author":1,"featured_media":323127,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-323126","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/323126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=323126"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/323126\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/323127"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=323126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=323126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=323126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}