{"id":6021,"date":"2020-08-24T15:32:33","date_gmt":"2020-08-24T13:32:33","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6021"},"modified":"2024-04-30T20:09:51","modified_gmt":"2024-04-30T18:09:51","slug":"getting-the-remainder-with-excels-mod-formula","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-remainder-with-excels-mod-formula\/","title":{"rendered":"How to get Remainder in Excel using MOD Formula"},"content":{"rendered":"<h3>How to get Remainder in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a> using MOD Formula<\/h3>\n<p>In Excel, it is very <strong>easy to divide<\/strong> two numbers.<\/p>\n<p>But how about if <strong>you\u00a0need to get the remainder from a division operation<\/strong>?<\/p>\n<p>For example, divide 13 by 4:<\/p>\n<ul>\n<li>Divide the two numbers (i.e. 13 \/ 4)<\/li>\n<li>Get the quotient (which is 3)<\/li>\n<li>Multiply it back to the divisor (3 * 4)<\/li>\n<li>Subtract it from the original number (13 &#8211; 12)<\/li>\n<li>And I have the remainder! (1)<\/li>\n<\/ul>\n<p>So, 4 goes into 13 three times with a remainder of 1.<\/p>\n<p>Thankfully we can do the above complex and manual calculation with ease <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-3-mod-7-with-mod-function\/\" target=\"_blank\" rel=\"noopener\">using Excel&#8217;s<\/a>\u00a0<strong>MOD<\/strong><strong>\u00a0formula!<\/strong><\/p>\n<p>In this tutorial, we will cover the following concepts in detail:<\/p>\n<div class=\"contents\"><\/div>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"mod-function-syntax-basic-use\"><\/a>MOD Function &#8211; Syntax &amp; Basic Use<\/strong><\/h3>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Gives you the remainder after dividing one number with another<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<h2>=MOD(<span style=\"color: #ff0000\"><span style=\"color: #339966\"><span style=\"color: #0000ff\">number1,\u00a0<span style=\"color: #339966\">number2<\/span><\/span><\/span><\/span>)<\/h2>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<ul>\n<li><span style=\"color: #0000ff\">number1 <span style=\"color: #000000\">&#8211; A number whose remainder you wish to find.<\/span><\/span><\/li>\n<li><span style=\"color: #339966\">number2 <span style=\"color: #000000\">&#8211; A number to divide with.<\/span><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>So, <strong>MOD(13,3)<\/strong> returns 1 as when you divide 13 by 3 will give a quotient of 4 and leaves a remainder of 1.<\/p>\n<p>Let&#8217;s look at a few examples to know how to get remainder in Excel using the MOD formula.<\/p>\n<div class=\"after-post-box\">\n<p>Follow the <strong>step-by-step tutorial<\/strong> on How to get Remainder in Excel using MOD Formula and make sure to <strong>download Excel Workbook<\/strong> to follow along:<\/p>\n<\/div>\n<div class=\"after-post-box\">\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\/08\/MOD-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-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\">MOD-FORMULA.xlsx<\/span><\/a><\/strong><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>We need to <strong>enter the <em>MOD\u00a0<\/em>function<\/strong>:<\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #0000ff\">=MOD(<\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6022\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-01.jpg\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"508\" height=\"159\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-01.jpg 508w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-01-300x94.jpg 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0The MOD arguments:<\/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\/getting-the-remainder-with-excels-mod-formula\/#number1\" title=\"number1\">number1<\/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\/getting-the-remainder-with-excels-mod-formula\/#number2\" title=\"number2\">number2<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"number1\"><\/span><em><strong><span style=\"color: #0000ff\">number1<\/span><\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>What is the first number that we plan to divide?<\/strong><\/p>\n<p><em>Reference <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/jump-to-a-cell-reference-within-an-excel-formula\/\" target=\"_blank\" rel=\"noopener\">the cell<\/a> that contains the\u00a0first number:<\/em><\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #000000\">=MOD<\/span><span style=\"color: #0000ff\">(C9,<\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6023\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-02.jpg\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"509\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-02.jpg 509w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-02-300x95.jpg 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"number2\"><\/span><em><strong><span style=\"color: #0000ff\">number2<\/span><\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>What is the divisor?<\/strong><\/p>\n<p><em>Reference the cell that contains the second number:<\/em><\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #000000\">=MOD<\/span><span style=\"color: #0000ff\"><span style=\"color: #000000\">(C9,<\/span> D9)<\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6024\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-03.jpg\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"530\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-03.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-03-300x92.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Do the same for the rest of the cells by dragging the <strong>MOD\u00a0<\/strong>formula all the way down using the left mouse button.<\/p>\n<p>Now you are able to get the remainders of all the division operations!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6025 size-full\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-04.jpg\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"493\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-04.jpg 493w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/MOD-FORMULA-04-300x113.jpg 300w\" sizes=\"(max-width: 493px) 100vw, 493px\" \/><\/a><\/p>\n<p>Now that you have learned how to use the MOD function to find the remainder. Let&#8217;s<strong> move on to some practical uses<\/strong> of this function.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"use-mod-function-to-highlight-cells\"><\/a>Use MOD function to Highlight Cells<\/strong><\/h3>\n<p>You can use the MOD function to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/pivot-tables\/conditional-formatting\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>conditionally format<\/strong><\/a> the cells. Say, you want to highlight every 4th row in your data.<\/p>\n<p>Let&#8217;s see the <strong>data table<\/strong> below:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-604.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19168 size-full\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-604-e1598283712712.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"631\" height=\"429\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-604-e1598283712712.png 631w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-604-e1598283712712-300x204.png 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s follow the<em> step-by-step tutorial<\/em> below to highlight every 4th row of this data table:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Select the entire data table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-605.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19169\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-605.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"657\" height=\"472\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-605.png 657w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-605-300x216.png 300w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Go to <strong>Home<\/strong> &gt; <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditionally-formatting-a-drop-down-list\/\" target=\"_blank\" rel=\"noopener\">Conditional Formatting<\/a><\/strong> &gt;<strong> New Rule<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-606.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19170\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-606.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"1079\" height=\"486\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-606.png 1079w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-606-300x135.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-606-1024x461.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-606-768x346.png 768w\" sizes=\"(max-width: 1079px) 100vw, 1079px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>In the New Formatting dialog box, select <strong>Use a formula to determine which <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-cells-special-numbers-excel\/\" target=\"_blank\" rel=\"noopener\">cells to format<\/a>\u00a0<\/strong>from the list.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-607.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19171\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-607.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"374\" height=\"366\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-607.png 374w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-607-300x294.png 300w\" sizes=\"(max-width: 374px) 100vw, 374px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong> <\/span>Type the formula<\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #0000ff\">=MOD(ROW(),4)=0<\/span><\/h2>\n<p>under <em>Format values where this formula is true<\/em> text box, and then click on Format button to apply custom formatting to these rows.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-608.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19172\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-608.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"374\" height=\"367\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-608.png 374w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-608-300x294.png 300w\" sizes=\"(max-width: 374px) 100vw, 374px\" \/><\/a><\/p>\n<p><em>Using this formula you can add formatting to every 4th row of the data. You can change the number to 2,3,5&#8230; as per your need.<\/em><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong> <\/span>In the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-1-format-cells\/\" target=\"_blank\" rel=\"noopener\">Format Cells<\/a> dialog box, Go to <strong>Fill<\/strong> Tab, and select an appropriate color. Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-609.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19173\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-609.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"530\" height=\"518\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-609.png 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-609-300x293.png 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6:<\/strong> <\/span>Here you can see a <strong><em>preview <\/em><\/strong>of how your formatted data will look like. If you are satisfied with it, click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-610.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19174\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-610.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"373\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-610.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-610-300x293.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Your conditionally formatted data table using the MOD formula is now ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-611.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19175\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-611.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"633\" height=\"439\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-611.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-611-300x208.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/a><\/p>\n<p>To highlight, the n<sup>th<\/sup> column you can simply replace the <strong>ROW<\/strong> formula with the <strong>COLUMN<\/strong> formula.<\/p>\n<p>This <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-table-conditional-formatting\/\" target=\"_blank\" rel=\"noopener\">conditional formatting<\/a> is <strong>dynamic<\/strong>, i.e. once you add or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-or-delete-rows-and-columns-in-excel\/\" target=\"_blank\" rel=\"noopener\">delete more rows<\/a> the formatting will update automatically.<\/p>\n<p>As you have seen, you can use the <strong>MOD function<\/strong> to highlight the nth row or column of your data. You can also use it to<strong> sum every nth row\/column<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"use-mod-function-to-calculate-cells\"><\/a>Use MOD function to Calculate cells<\/strong><\/h3>\n<p>In the data below, you have sales data for different products &amp; different regions.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-612.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19179\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-612.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"443\" height=\"272\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-612.png 443w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-612-300x184.png 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p>You can use the <strong>MOD function, to sum up<\/strong>, every alternate row in the data to get the total sales of the North and South regions separately.<\/p>\n<p>&nbsp;<\/p>\n<p>The formula for the sum of every <strong>even row (North Region Sales)<\/strong> :<\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #0000ff\">=SUMPRODUCT(- -(MOD(ROW(range),2)=0),range)<\/span><\/h2>\n<p>The formula for the sum of every<strong> odd row (South Region Sales)<\/strong> :<\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #0000ff\">=SUMPRODUCT(- -(MOD(ROW(range),2)=1),range)<\/span><\/h2>\n<p>Here,<\/p>\n<ul>\n<li>The <strong>ROW<\/strong> function returns the row number of the cell.<\/li>\n<li><strong>MOD<\/strong> function when divides an <strong>even number leaves remainder as 0<\/strong> and when divides an <strong>odd number leaves remainder as 1<\/strong>.<\/li>\n<li><strong>Double dashes (- -)<\/strong> outside the MOD function converts the FALSE and TRUE into 0s and 1s.<\/li>\n<li>Lastly, <b>SUMPRODUCT <\/b>function multiplies the sum of the product of range containing 0s and 1s and range containing sales amount.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>The formula for calculating<strong> total sales in North Region<\/strong> i.e., the summation of all <strong>even rows (Row 2, Row 4, Row 6 &amp; Row 8)<\/strong>\u00a0will be:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-613.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19182\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-613.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"786\" height=\"336\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-613.png 786w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-613-300x128.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-613-768x328.png 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The formula for calculating<strong> total sales in South Region<\/strong> i.e., the summation of all <strong>odd rows<\/strong> <strong> (Row 3, Row 5, Row 7 &amp; Row 9)<\/strong>\u00a0 will be:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-614.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19183\" title=\"How to get Remainder in Excel using MOD Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-614.png\" alt=\"How to get Remainder in Excel using MOD Formula\" width=\"828\" height=\"366\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-614.png 828w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-614-300x133.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-614-768x339.png 768w\" sizes=\"(max-width: 828px) 100vw, 828px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Conclusion<\/strong><\/h3>\n<p>In this tutorial, you have learned not only <strong>how to get remainder in Excel<\/strong> but also how to use the <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">MOD function<\/a> to highlight and calculate cells<\/strong>.<\/p>\n<p>To know more about various functions available in Excel, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Click Here<\/strong><\/a>!<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/\" target=\"_blank\" rel=\"noopener\">How to Master Excel Formulas &#8211; The Ultimate Guide<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">101 Advanced Excel Formulas &amp; Functions Examples<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener\">3 Quick Ways to Remove Formulas in Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How to get Remainder in Excel using MOD Formula In Excel, it is very easy to divide two numbers. But how about if you\u00a0need to get the remainder from a division operation? For example, divide 13 by 4: Divide the two numbers (i.e. 13 \/ 4) Get the quotient (which is 3) Multiply it back [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17534,"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 get Remainder in Excel using MOD Formula","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15,287],"tags":[142,235],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6021"}],"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=6021"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6021\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17534"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}