{"id":7017,"date":"2020-07-28T11:00:07","date_gmt":"2020-07-28T09:00:07","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=7017"},"modified":"2024-04-10T04:42:11","modified_gmt":"2024-04-10T02:42:11","slug":"division-formula-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/division-formula-excel\/","title":{"rendered":"How to Divide in Excel with the Division Formula"},"content":{"rendered":"<p>There are numerous exciting ways to <strong>divide numbers<\/strong> and cells in Excel.<\/p>\n<p>Let&#8217;s discuss each of the following points regarding the Division in Excel:<\/p>\n<ul>\n<li><a href=\"#using-division-formula-operator\"><strong>Using Division Formula\/Operator<\/strong><\/a><\/li>\n<li><a href=\"#divide-by-a-constant-number\"><strong>Divide by a Constant Number<\/strong><\/a><\/li>\n<li><a href=\"#using-quotient-function\"><strong>Using Quotient Function<\/strong><\/a><\/li>\n<li><a href=\"#div-error-in-excel-division-formula\"><strong>#DIV\/0! Error in Excel Division Formula<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"using-division-formula-operator\"><\/a>Using Division Formula\/Operator<\/strong><\/h3>\n<p>The most common way to divide in Excel is to use the Division operator i.e. the forward-slash symbol (\/).<\/p>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Divides two numbers<\/p>\n<p><strong style=\"font-style: italic;\">Formula breakdown:<\/strong><\/p>\n<p>=<span style=\"color: #0000ff;\">number1<\/span> \/ <span style=\"color: #ff6600;\">number2<\/span><\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=<span style=\"color: #0000ff;\">the number being divided<\/span> \/ <span style=\"color: #ff6600;\">the number you are dividing by<\/span><\/p>\n<hr \/>\n<p>In Excel, you can divide two numbers very easily using the <strong>Division formula<\/strong>!<\/p>\n<p>The <strong>Division Formula<\/strong> is done through the use of the division operator which is depicted by a forward slash:\u00a0\u00a0<span style=\"color: #0000ff;\"><strong>\/<\/strong><\/span><\/p>\n<p>I will show you in the steps below how you can divide numbers in Excel.<\/p>\n<p>This is the table of values that we want to perform division on:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-7018\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-01.jpg\" alt=\"How to Divide in Excel with the Division Formula\" width=\"590\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-01.jpg 590w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-01-300x81.jpg 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Wwsq_sXegGg?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/DIVISION-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">DIVISION-FORMULA.xlsx<\/span><\/a><\/strong><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>We need to <strong>enter the number we want to divide<\/strong>:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/division-formula-excel\/#C9\" title=\"=C9\">=C9<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/division-formula-excel\/#C9-2\" title=\"=C9 \/\">=C9 \/<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/division-formula-excel\/#C9_D9\" title=\"=C9 \/ D9\">=C9 \/ D9<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"C9\"><\/span>=<span style=\"color: #0000ff;\">C9<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-7019\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-02.jpg\" alt=\"How to Divide in Excel with the Division Formula\" width=\"589\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-02.jpg 589w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-02-300x84.jpg 300w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong>\u00a0<\/span>Enter the <strong>division operator <span style=\"color: #0000ff;\">\/<\/span><\/strong><\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"C9-2\"><\/span>=C9 <span style=\"color: #0000ff;\">\/<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-7020\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-03.jpg\" alt=\"How to Divide in Excel with the Division Formula\" width=\"594\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-03.jpg 594w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-03-300x82.jpg 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong>\u00a0<\/span>Enter the <strong>number we are dividing by<\/strong>:<\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"C9_D9\"><\/span>=C9 \/ <span style=\"color: #0000ff;\">D9<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone wp-image-7021 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-04.jpg\" alt=\"How to Divide in Excel with the Division Formula\" width=\"588\" height=\"159\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-04.jpg 588w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-04-300x81.jpg 300w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p>You now have all of the division results!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-7022\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-05.jpg\" alt=\"How to Divide in Excel with the Division Formula\" width=\"612\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-05.jpg 612w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/DIVISION-FORMULA-05-300x91.jpg 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"divide-by-a-constant-number\"><\/a>Divide by a Constant Number<\/strong><\/h3>\n<p>In the example below, you have the <strong>total sales achieved each month<\/strong> by a company. You want to convert the sales amount in $ &#8216;000 i.e. you want to divide each sales amount by 1000.<\/p>\n<p>&nbsp;<\/p>\n<p>How can you <strong>quickly divide the sales amount by a constant value<\/strong> i.e. 1000?<\/p>\n<p>Follow the<strong> step-by-step tutorial<\/strong> below to achieve the desired result:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Insert the <strong>divisor (i.e. 1000)<\/strong> in cell G6<strong>.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-359-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18784\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-359-1.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"453\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-359-1.png 453w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-359-1-300x218.png 300w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span><strong>Copy<\/strong> the value in cell G6. It will be saved in the clipboard.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-361-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18783\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-361-1.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"455\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-361-1.png 455w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-361-1-300x218.png 300w\" sizes=\"(max-width: 455px) 100vw, 455px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span><strong>Highlight<\/strong> the cells in Column E.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-362.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18782\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-362.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"446\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-362.png 446w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-362-300x220.png 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>Press <strong>Alt + E + S<\/strong> to open the <strong>Paste Special<\/strong> dialog box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-364.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18785\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-364.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"400\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-364.png 400w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-364-300x247.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong> <\/span>Press <strong>I\u00a0<\/strong>to select the <strong>Divide<\/strong> option. Press OK.<\/p>\n<p><em><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-365.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18786\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-365.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"398\" height=\"333\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-365.png 398w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-365-300x251.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/a><\/em><\/p>\n<p><em>The values in Column D is divided by 1000.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-366.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18787\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-366.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"316\" height=\"321\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-366.png 316w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-366-295x300.png 295w\" sizes=\"(max-width: 316px) 100vw, 316px\" \/><\/a><\/p>\n<p>So, you can easily divide the numbers by a constant value using the paste special option in Excel.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"using-quotient-function\"><\/a>Using Quotient Function<\/strong><\/h3>\n<p>The Quotient Function is used to divide two numbers and <strong>return only the integer portion<\/strong> of the division. It does not provide the remainder and hence can be used when you want to <strong>omit the remainder<\/strong>.<\/p>\n<p><em>If two numbers divide evenly without any remainder, then the result for both Division Operator (\/) and Quotient function will be the same.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>The <strong>Syntax<\/strong> of Quotient Function is:<\/p>\n<p><strong>=QUOTIENT(numerator, denominator)<\/strong><\/p>\n<p>where;<\/p>\n<ul>\n<li><strong>Numerator<\/strong>\u00a0&#8211; the dividend, i.e. the number to be divided.<\/li>\n<li><strong>Denominator<\/strong> &#8211; the divisor, i.e. the number to divide by.<\/li>\n<\/ul>\n<p>Make sure that the arguments mentioned in numerator and denominator are numeric, otherwise the QUOTIENT will return #VALUE! error.<\/p>\n<p>Let&#8217;s take an <strong>example<\/strong> to see how this function work:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-367.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18788\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-367.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"436\" height=\"377\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-367.png 436w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-367-300x259.png 300w\" sizes=\"(max-width: 436px) 100vw, 436px\" \/><\/a><\/p>\n<p>Here, you have the total sales achieved by a company each month and the average sale price per product.<\/p>\n<p>Now, you want to know the <strong>number of products sold<\/strong> each month!<\/p>\n<p>This can be done using the Quotient Function to divide total sales by average price per product. As the result of this function will provide you with the <strong>integer portion<\/strong> of the division.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select cell F6 and type <strong>= <\/strong>to start the formula.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-368.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18790\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-368.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"584\" height=\"464\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-368.png 584w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-368-300x238.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Type <strong>Quotient\u00a0<\/strong>and open bracket <strong>(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-369.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18791\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-369.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"660\" height=\"464\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-369.png 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-369-300x211.png 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>Select <strong>Cell D6<\/strong> to insert Total sales as the numerator and then type<strong> ,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-370-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18793\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-370-1.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"614\" height=\"470\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-370-1.png 614w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-370-1-300x230.png 300w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>Select <strong>Cell E6<\/strong> to insert Average price per Product as a denominator and then enter close bracket <strong>)<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-371.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18794\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-371.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"593\" height=\"514\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-371.png 593w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-371-300x260.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong> <\/span>Press Enter.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-372.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18795\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-372.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"562\" height=\"464\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-372.png 562w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-372-300x248.png 300w\" sizes=\"(max-width: 562px) 100vw, 562px\" \/><\/a><\/p>\n<p>This will provide you with only the integer portion of the division formula in Excel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-373.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18796\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-373.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"454\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-373.png 454w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-373-300x262.png 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"div-error-in-excel-division-formula\"><\/a>#DIV\/0! Error in Excel Division Formula<\/strong><\/h3>\n<p>Excel shows a #DIV\/0! error when you try to divide a number by 0 or with a blank cell.<\/p>\n<p>If you try a formula like =5\/0, it will produce an error.<\/p>\n<p>Look at the example below, when you tried to divide 6441 by 0 Excel has provided you with an #DIV\/0! error.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-374.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18797\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-374.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"571\" height=\"415\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-374.png 571w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-374-300x218.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/a><\/p>\n<p>You can easily replace this error with a custom text that you want using an <strong>IFERROR function<\/strong>.<\/p>\n<p>IFERROR function returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.<\/p>\n<p>The syntax of IFERROR is =IFERROR(value,value_if_error)<\/p>\n<ul>\n<li><strong>value<\/strong> &#8211; It is any value or cell reference or an expression.<\/li>\n<li><strong>value_if_error<\/strong> &#8211; The text\/value you want to display if the first argument returns an error.<\/li>\n<\/ul>\n<p>Let&#8217;s use this function in our example, to replace the error with a blank.<\/p>\n<p>You can use the formula<strong> =IFERROR(B7\/C7,&#8221;&#8221;)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-375.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Divide in Excel with the Division Formula\"  class=\"alignnone size-full wp-image-18798\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-375.png\" alt=\"How to Divide in Excel with the Division Formula\" width=\"421\" height=\"422\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-375.png 421w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-375-300x300.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Screenshot-375-150x150.png 150w\" sizes=\"(max-width: 421px) 100vw, 421px\" \/><\/a><\/p>\n<p>The #DIV\/0! error has been replaced!!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"conclusion\"><\/a>Conclusion<\/strong><\/h3>\n<p>In this article, you have been provided with a detailed guide on how to divide in Excel using the division operator and quotient function.<\/p>\n<p>You can learn more about Excel formulas &amp; functions and become better at Excel by<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/\" target=\"_blank\" rel=\"noopener noreferrer\">clicking here.<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 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=\"wp-image-14329 size-medium alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" 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\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\"><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>,<\/strong> and <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot.jpg?x85520\" alt=\"Excel Pivot Table\" width=\"530\" height=\"300\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are numerous exciting ways to divide numbers and cells in Excel. Let&#8217;s discuss each of the following points regarding the Division in Excel: Using Division Formula\/Operator Divide by a Constant Number Using Quotient Function #DIV\/0! Error in Excel Division Formula Conclusion &nbsp; Using Division Formula\/Operator The most common way to divide in Excel is [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17168,"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 Divide in Excel with the Division Formula","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15,315],"tags":[263,676,142,677],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7017"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7017"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7017\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17168"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}