{"id":52,"date":"2016-03-01T04:09:02","date_gmt":"2016-03-01T04:09:02","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=52"},"modified":"2024-11-14T13:50:11","modified_gmt":"2024-11-14T02:50:11","slug":"mod-function-excel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel","title":{"rendered":"The MOD Function in Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The <strong>MOD<\/strong> function is useful maths function that will return the remainder after a division has taken place. MOD is an abbreviation of <strong>modulo<\/strong> or <strong>modulus<\/strong>. While it actually performs division based on the two arguments that must be given, it only returns the amount remaining after that division has occurred. Follow on to learn how it works!<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">The general function to calculate remainder after division is <strong>=MOD(number, divisor)<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before you start, ensure that the data you are working with in your Excel worksheet looks similar to the first screen capture.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"748\" height=\"322\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg\" alt=\"ExcelMODFunction-1-DynamicWebTraining\" class=\"wp-image-53\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg 748w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining-300x129.jpg 300w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Use MOD Function<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 1<\/span><\/strong>:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In cell B10 enter the RONDDOWN formula (=ROUNDDOWN(B7\/B9,0)).Step 2: In cell C7 enter the IF function (=IF(C5=0,0,C5+C6)).<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"748\" height=\"324\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-2-DynamicWebTraining.jpg\" alt=\"ExcelMODFunction-2-DynamicWebTraining\" class=\"wp-image-54\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-2-DynamicWebTraining.jpg 748w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-2-DynamicWebTraining-300x130.jpg 300w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 2<\/span><\/strong>:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In cell C7 enter the IF function (=IF(C5=0,0,C5+C6)).<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"323\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-3-DynamicWebTraining.jpg\" alt=\"ExcelMODFunction-3-DynamicWebTraining\" class=\"wp-image-55\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-3-DynamicWebTraining.jpg 750w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-3-DynamicWebTraining-300x129.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 3<\/span><\/strong>:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, select cell B5 and type in 279.39, then press ENTER. This should assist you in entering tips taken from Week 1. You will notice that 55.00 will appear in cell B10. This amount is calculated from the ROUNDOWN formula, which you previously entered and represents the tips that each employee will receive.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"749\" height=\"325\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-4-DynamicWebTraining.jpg\" alt=\"ExcelMODFunction-4-DynamicWebTraining\" class=\"wp-image-56\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-4-DynamicWebTraining.jpg 749w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-4-DynamicWebTraining-300x130.jpg 300w\" sizes=\"auto, (max-width: 749px) 100vw, 749px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 4<\/span><\/strong>:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Continue on to cell B11, type in =MOD(B7, B9), then press ENTER to see the remainder after the 55.00 has been dispersed.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"323\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-5-DynamicWebTraining-.jpg\" alt=\"ExcelMODFunction-5-DynamicWebTraining\" class=\"wp-image-57\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-5-DynamicWebTraining-.jpg 747w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-5-DynamicWebTraining--300x130.jpg 300w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 5<\/span><\/strong>:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">While still having B11 selected, drag the fill handle across to column G.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"808\" height=\"324\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-6-DynamicWebTraining.jpg\" alt=\"ExcelMODFunction-6-DynamicWebTraining\" class=\"wp-image-58\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-6-DynamicWebTraining.jpg 808w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-6-DynamicWebTraining-300x120.jpg 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-6-DynamicWebTraining-768x308.jpg 768w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">STEP 6<\/span><\/strong>:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select cell C5, type in 367.95, then press ENTER to see how the formulas update!<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"748\" height=\"322\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-7-DynamicWebTraining.jpg\" alt=\"ExcelMODFunction-7-DynamicWebTraining\" class=\"wp-image-59\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-7-DynamicWebTraining.jpg 748w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-7-DynamicWebTraining-300x129.jpg 300w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The MOD function is useful maths function that will return the remainder after a division has taken place. MOD is an abbreviation of modulo or modulus. While it actually performs division based on the two arguments that must be given, it only returns the amount remaining after that division has occurred. Follow on to learn&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-52","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"<title>The MOD Function in Excel - Dynamic Web Training Blog<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The MOD Function in Excel\" \/>\n<meta property=\"og:description\" content=\"MOD function in Excel is useful maths function that will return the remainder after a division has taken place. MOD is an abbreviation of modulo or modulus\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-01T04:09:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T02:50:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"The MOD Function in Excel\",\"datePublished\":\"2016-03-01T04:09:02+00:00\",\"dateModified\":\"2024-11-14T02:50:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel\"},\"wordCount\":275,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/ExcelMODFunction-1-DynamicWebTraining.jpg\",\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel\",\"name\":\"The MOD Function in Excel - Dynamic Web Training Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/ExcelMODFunction-1-DynamicWebTraining.jpg\",\"datePublished\":\"2016-03-01T04:09:02+00:00\",\"dateModified\":\"2024-11-14T02:50:11+00:00\",\"description\":\"MOD function in Excel is useful maths function that will return the remainder after a division has taken place. MOD is an abbreviation of modulo or modulus\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/ExcelMODFunction-1-DynamicWebTraining.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/ExcelMODFunction-1-DynamicWebTraining.jpg\",\"width\":748,\"height\":322},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/mod-function-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-excel\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"The MOD Function in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"}]}<\/script>","yoast_head_json":{"title":"The MOD Function in Excel - Dynamic Web Training Blog","description":"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights","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:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel","og_locale":"en_US","og_type":"article","og_title":"The MOD Function in Excel","og_description":"MOD function in Excel is useful maths function that will return the remainder after a division has taken place. MOD is an abbreviation of modulo or modulus","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2016-03-01T04:09:02+00:00","article_modified_time":"2024-11-14T02:50:11+00:00","og_image":[{"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg","type":"","width":"","height":""}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel#article","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel"},"author":{"name":"Dynamic Web Training","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233"},"headline":"The MOD Function in Excel","datePublished":"2016-03-01T04:09:02+00:00","dateModified":"2024-11-14T02:50:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel"},"wordCount":275,"publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg","articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel","name":"The MOD Function in Excel - Dynamic Web Training Blog","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel#primaryimage"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg","datePublished":"2016-03-01T04:09:02+00:00","dateModified":"2024-11-14T02:50:11+00:00","description":"MOD function in Excel is useful maths function that will return the remainder after a division has taken place. MOD is an abbreviation of modulo or modulus","breadcrumb":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelMODFunction-1-DynamicWebTraining.jpg","width":748,"height":322},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mod-function-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel"},{"@type":"ListItem","position":4,"name":"The MOD Function in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","name":"Dynamic Web Training Blog","description":"The Ultimate Training Experience.","publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain"],"url":"https:\/\/www.dynamicwebtraining.com.au"}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/52","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=52"}],"version-history":[{"count":5,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/52\/revisions"}],"predecessor-version":[{"id":1945,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/52\/revisions\/1945"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}