{"id":23853,"date":"2021-06-01T22:19:58","date_gmt":"2021-06-01T20:19:58","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23853"},"modified":"2024-02-06T16:05:50","modified_gmt":"2024-02-06T15:05:50","slug":"div-error-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/div-error-in-excel\/","title":{"rendered":"How to fix the #DIV\/0! error in Excel Formulas"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #DIV\/0! error in Excel Formulas\"  class=\"size-full wp-image-23914 aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/16.png\" alt=\"How to fix the #DIV\/0! error in Excel Formulas\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/16.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/16-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/16-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><br \/>\nThe #DIV\/0!\u00a0 error is a<strong> simple error<\/strong> to understand. It can<strong> occur mainly<\/strong> when we attempt to <strong>divide two values, directly or referenced<\/strong> in certain cells. It is basically caused <strong>when the divisor is 0<\/strong>.<\/p>\n<p>In this article, you will learn the following:<\/p>\n<ul>\n<li><a href=\"#what-is-div-error-in-excel\"><strong>What is #DIV error in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-fix-div-error-in-excel\"><strong>How to fix #DIV error in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s <strong>consider different examples<\/strong> to examine different causes of #DIV error and learn how to get rid of DIV 0! Download the Excel Workbook below to follow along and understand better:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Div-error.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Top-20-Common-Excel-Errors.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Div-error.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><a id=\"what-is-div-error-in-excel\"><\/a><strong>What is #DIV error in Excel?<\/strong><\/h3>\n<p>Excel may return the #DIV\/0! error when the:<\/p>\n<ul>\n<li>Number is <strong>divided by blank cell<\/strong><\/li>\n<li>Number is<strong>\u00a0divided by 0<\/strong><\/li>\n<\/ul>\n<p>If we click the <strong>exclamation warning sign beside #DIV\/0! Error<\/strong>, excel would explain that \u201cThe <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> or function used is dividing by zero or empty cells.\u201d<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"how-to-fix-div-error-in-excel\"><\/a>How to fix #DIV Error In Excel<\/strong><\/h3>\n<p><span style=\"color: #339966;\"><strong>Example 1 &#8211; Number is divided by blank cell<\/strong><\/span><\/p>\n<p>The Excel DIV 0 is a <strong>common and simple error that can easily be dealt with<\/strong>. To <strong>correct<\/strong> this error, all we have to do is make sure that the <strong>cell reference provided does not belong to an empty cell<\/strong>.<\/p>\n<p>In the example below, the formula in column C is a simple dividing formula. But, cells B9 and B12 have <strong>blank cells<\/strong> respectively, and hence result from the <strong>division in column C returns the #DIV\/0<\/strong>\u00a0Error.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.08.38-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #DIV\/0! error in Excel Formulas\"  class=\"alignnone wp-image-23917 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.08.38-PM.png\" alt=\"How to fix the #DIV\/0! error in Excel Formulas\" width=\"353\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.08.38-PM.png 353w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.08.38-PM-300x278.png 300w\" sizes=\"(max-width: 353px) 100vw, 353px\" \/><\/a><\/p>\n<p>Now if we simply <strong>correct our mistakes by editing the cells in column B<\/strong>, the errors will disappear.<\/p>\n<p>Like so!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.10.27-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #DIV\/0! error in Excel Formulas\"  class=\"alignnone size-full wp-image-23918\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.10.27-PM.png\" alt=\"How to fix the #DIV\/0! error in Excel Formulas\" width=\"383\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.10.27-PM.png 383w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.10.27-PM-300x283.png 300w\" sizes=\"(max-width: 383px) 100vw, 383px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>Example 2 &#8211; Using the IF function<\/strong><\/span><\/p>\n<p>In most cases, the <strong>referenced cell should actually contain the value 0 or be empty<\/strong>. A <strong>simple solution<\/strong> to this will be to <strong>use an IFERROR formula<\/strong> and get rid of the error message.<\/p>\n<p>We can design the IFERROR formula in such a way that it <strong>either returns 0 or any value as desired if the result of the original <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> occurs to be an error<\/strong>.<\/p>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>It returns a value that you set if a formula has an error<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p><span style=\"color: #339966;\"><strong>=IFERROR(Value, Value if Error)<\/strong><\/span><\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p><span style=\"color: #339966;\"><strong>=IFERROR(The Formula, What do you want to show if The Formula has an error?)<\/strong><\/span><\/p>\n<p>If you have a calculation that results in an error like, #N\/A, #VALUE!, #REF!, #DIV\/0!, #NUM!, #NAME?, then you can <strong>clean it up by using the IFERROR\u00a0function<\/strong> which allows you to <strong>replace the error it with a custom text<\/strong>.<\/p>\n<p>In this example, cell B9 contains 0, and cell B12 is empty. The corresponding cells C7 and C12 are thus displaying #DIV error.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.12.57-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #DIV\/0! error in Excel Formulas\"  class=\"alignnone size-full wp-image-23919\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.12.57-PM.png\" alt=\"How to fix the #DIV\/0! error in Excel Formulas\" width=\"356\" height=\"351\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.12.57-PM.png 356w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.12.57-PM-300x296.png 300w\" sizes=\"(max-width: 356px) 100vw, 356px\" \/><\/a><\/p>\n<p>Let&#8217;s wrap the division formula around the <strong>IFERROR formula<\/strong> and see what happens.<\/p>\n<p><span style=\"color: #339966;\"><strong>=IFERROR(A7\/B7,&#8221;-&#8220;)<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.20.15-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #DIV\/0! error in Excel Formulas\"  class=\"alignnone wp-image-23921 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.20.15-PM.png\" alt=\"How to fix the #DIV\/0! error in Excel Formulas\" width=\"359\" height=\"345\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.20.15-PM.png 359w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.20.15-PM-300x288.png 300w\" sizes=\"(max-width: 359px) 100vw, 359px\" \/><\/a><\/p>\n<p>Here, we specified in the formula that if the<strong> value in cell C7 returns an error<\/strong>, it will be<strong> replaced by our custom text &#8211; hyphen (-)<\/strong>.<\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.16.01-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #DIV\/0! error in Excel Formulas\"  class=\"alignnone size-full wp-image-23920\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.16.01-PM.png\" alt=\"How to fix the #DIV\/0! error in Excel Formulas\" width=\"358\" height=\"370\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.16.01-PM.png 358w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-01-at-8.16.01-PM-290x300.png 290w\" sizes=\"(max-width: 358px) 100vw, 358px\" \/><\/a><\/p>\n<p>Hence as cells <strong>B9 and B12 had blank or 0 values<\/strong>, the corresponding <strong>cells in column C<\/strong> should produce an error but IFERROR changes it to <strong>display hyphen (-)<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"conclusion\"><\/a>Conclusion<\/strong><\/h3>\n<p>So it&#8217;s clear now that the DIV 0 error is simply caused when a number is being divided by 0 or a blank cell. If <strong>any <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/other\/\" target=\"_blank\" rel=\"noopener\">other formula<\/a> is applied on the cell displaying the #DIV\/0!<\/strong> Error, then it will <strong>also show the same error.<\/strong><\/p>\n<p>Now you can easily <strong>overcome this problem and continue with smooth functioning in Excel<\/strong>!<\/p>\n<p><strong>Click here<\/strong> to learn about the Top 20 Common Errors that you may encounter while working on Excel.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" title=\"Top 20 Common Excel Problems Solved | MyExcelOnline\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" sizes=\"(max-width: 300px) 100vw, 300px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" alt=\"Microsoft Excel Training\" width=\"300\" height=\"200\" \/><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"nofollow noopener\">Formulas<\/a>,\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>,\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/power-query-data-cleansing-webinar.html\" target=\"_blank\">Power Query<\/a>,<\/strong>\u00a0and\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The #DIV\/0!\u00a0 error is a simple error to understand. It can occur mainly when we attempt to divide two values, directly or referenced in certain cells. It is basically caused when the divisor is 0. In this article, you will learn the following: What is #DIV error in Excel? How to fix #DIV error in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":23914,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to fix the #DIV\/0! error in Excel Formulas","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15],"tags":[727,725,726],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23853"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23853"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/23914"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}