{"id":15054,"date":"2024-02-02T14:52:51","date_gmt":"2024-02-02T14:52:51","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=15054"},"modified":"2024-02-02T14:52:51","modified_gmt":"2024-02-02T14:52:51","slug":"mod-of-big-numbers-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/","title":{"rendered":"Calculate MOD of Large Numbers in Excel"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.17.6″ custom_padding=”0px|0px|0px|0px|false|false” da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

Excel Trick to Calculate MOD of Big Numbers. <\/h2>\n

This article is all about MOD function in Excel. Every aspect of the MOD function is covered here in this article. At the end of this article, I have also explained a VBA code to calculate the MOD of large numbers.
\nI have also explained the shortcomings of the MOD formula in Excel and how to overcome those shortcomings.<\/p>\n

Let’s start with the basics – What is the MOD function?<\/p>\n

What is MOD Function in Excel<\/h2>\n

MOD is a short form of Modulus. Modulus is a function that returns the remainder when you divide a number with another number.
\nFor Example:<\/strong> 19 MOD 5 = 4 ( Explanation : If you divide 19 with 5 then remainder will be 4 (5*3 = 15 and 19-15 = 4)<\/p>\n

How to calculate MOD using Excel Formula<\/h2>\n

Using simple Excel Formula, you can easily calculate the MOD of any 2 numbers.<\/p>\n

\"MOD<\/a>

MOD Function<\/p><\/div>\n

As shown in the above picture, you can see there are two input parameters required for this Function. Number and Divisor.<\/em><\/p>\n

Important Note:<\/h3>\n

Using the above formula, you can calculate MOD of a maximum of 12 digits. If number goes beyond 12 digits, then you get #NUM!<\/strong> error as shown below:<\/em><\/p>\n

\"Mod<\/a>

Mod Error for Big Numbers<\/p><\/div>\n

Need of Calculating MOD of Big Numbers<\/h2>\n

Yesterday, In office, one of my colleague (Bas Vermeulen) was trying to calculate the IBAN Numbers<\/a> for a Given BANK Name, Country Code and Bank Account Number. In the process of calculating IBAN Number, he needed to calculate MOD-97<\/em> <\/strong>of really bog number (approx 22 digit number).<\/p>\n

Therefore, to help him, I created a VBA function that can calculate the MOD of any number of digits<\/p>\n

VBA Code to Calculate MOD of Big Numbers<\/h2>\n

To overcome the MOD function error, I came up with the following logic, so that no matter how big the number is, MOD can still be calculated. Therefore, I went back to the basics of Division, which I had studied in my school days – How to divide a big number.<\/p>\n

So here is what you do.<\/p>\n

\n

Step 1: <\/strong>First pick up the first n length of digit from the Large Number provided (Where n = Length of Divisor + 1) – Just to make sure that the big number is divided by a small number.
\nStep 2: <\/strong>Now for this subset of the digit, it is easy to calculate the MOD and get the Remainder
\nStep 3: <\/strong>Now, simply append this remainder in the remaining digit of the larger number
\nStep 4: <\/strong>Now using this as a new Number repeat the steps from Step 1…<\/p>\n

Refer to the image below for more clarity<\/p>\n

\"Find

Find MOD Manually – Divide Method<\/p><\/div>\n<\/div>\n

With the above process, it is clear that, if we automate the above step in VBA then, there you can calculate the MOD of any big number. Because at a time, you are dividing a subset of the whole number. The number of iterations will increase based on how big the number is – but it will be able to calculate.<\/p>\n

\nFunction MODForBigNum(bigNum As String, modVal As Integer) As Integer\n   \n    Dim currentLenNum As Integer\n    Dim partitionCount As Integer\n    Dim remainingString As String\n    \n    currentLenNum = VBA.Len(bigNum)\n    partitionCount = VBA.Len(modVal) + 1\n    \n    remainingString = bigNum\n   \n    While currentLenNum > partitionCount\n        stringToInt = VBA.Left(remainingString, partitionCount)\n        remainingString = VBA.Right(remainingString, currentLenNum - partitionCount)\n        remainder = stringToInt - (Int(stringToInt \/ modVal) * modVal)\n        remainingString = remainder & remainingString\n        currentLenNum = VBA.Len(remainingString)\n    Wend\n    \n    MODForBigNum = remainingString - (Int(remainingString \/ modVal) * modVal)\n    \nEnd Function\n<\/code><\/pre>\n
There is one shortcoming in the above code – in case when Divisor is more than 5 digits – it will give an error<\/strong><\/em>
\nTo overcome the above problem, I did some changes to the above code and now it should be working any number of Number and Divisor<\/em> <\/strong><\/p>\n
The only, issue with the below function is that it accepts Divisor as a string and also returns the result as a string.<\/p>\n
\nFunction MODForBigNum2(bigNum As String, modVal As String) As String\n   \n    Dim currentLenNum As Integer\n    Dim partitionCount As Integer\n    Dim remainingString As String\n    \n    currentLenNum = VBA.Len(bigNum)\n    partitionCount = VBA.Len(modVal) + 1\n    \n    remainingString = bigNum\n   \n    While currentLenNum > partitionCount\n        stringToInt = VBA.Left(remainingString, partitionCount)\n        remainingString = VBA.Right(remainingString, currentLenNum - partitionCount)\n        remainder = stringToInt - (Int(stringToInt \/ modVal) * modVal)\n        remainingString = remainder & remainingString\n        currentLenNum = VBA.Len(remainingString)\n    Wend\n    \n    MODForBigNum2 = remainingString - (Int(remainingString \/ modVal) * modVal)\n    \nEnd Function\n<\/code><\/pre>\n
Calculate Mod-97 of Large Numbers in Excel<\/h3>\n
 So, now you have a solution to calculate Mod for a big Number and Big Divisor.
\nIn my next article, I will Publish a Tool to calculate IBAN Numbers automatically.[\/et_pb_text][et_pb_blurb title=”Suggested Articles:” use_icon=”on” font_icon=”||fa||900″ _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ hover_enabled=”0″ icon_font_size=”2em” saved_tabs=”all” global_colors_info=”%91%93″ custom_css_blurb_image_phone=”position:absolute;||margin-bottom: 0px;||border: 0.5em solid #30657f !important;||box-shadow: 0 0 0 0.2em #fff;||border-radius:50%;||background: #30657f;||transform: translateX(-3.7em);” sticky_enabled=”0″]<\/p>\n
    \n
  1. DATEDIF WORKSHEET FUNCTION : AGE CALCULATION<\/a><\/li>\n
  2. EXCEL UDF: TO EXTRACT ALL NUMBERS, SPECIAL<\/a><\/li>\n
  3. CHARACTERS AND ALPHABETS FROM A STRING<\/a><\/li>\n
  4. USER DEFINED FUNCTION IN EXCEL TO CONVERT CURRENCY TO WORDS<\/a><\/li>\n
  5. EXCEL FORMULA : DATE AND TIME FORMULA<\/a><\/li>\n<\/ol>\n
    [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
    Excel Trick to Calculate MOD of Big Numbers. This article is all about MOD function in Excel. Every aspect of the MOD function is covered here in this article. At the end of this article, I have also explained a VBA code to calculate the MOD of large numbers. I have also explained the shortcomings […]<\/p>\n","protected":false},"author":45,"featured_media":242618,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672,1673,1246,1676],"tags":[],"class_list":["post-15054","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-formula","category-excel-functions","category-macro","category-excel-tips"],"yoast_head":"\nCalculate MOD of Large Numbers in Excel - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"MOD of large numbers in excel | MOD calculation error for Big Numbers | VBA Function to calculate MOD of Big Numbers | MOD-97 of Large Numbers | IBAN generate\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculate MOD of Large Numbers in Excel\" \/>\n<meta property=\"og:description\" content=\"MOD of large numbers in excel | MOD calculation error for Big Numbers | VBA Function to calculate MOD of Big Numbers | MOD-97 of Large Numbers | IBAN generate\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-02T14:52:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"809\" \/>\n\t<meta property=\"og:image:height\" content=\"604\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Calculate MOD of Large Numbers in Excel\",\"datePublished\":\"2024-02-02T14:52:51+00:00\",\"dateModified\":\"2024-02-02T14:52:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/\"},\"wordCount\":850,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png\",\"articleSection\":[\"Excel Formula\",\"Excel Functions\",\"Excel Macro\",\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/\",\"name\":\"Calculate MOD of Large Numbers in Excel - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png\",\"datePublished\":\"2024-02-02T14:52:51+00:00\",\"dateModified\":\"2024-02-02T14:52:51+00:00\",\"description\":\"MOD of large numbers in excel | MOD calculation error for Big Numbers | VBA Function to calculate MOD of Big Numbers | MOD-97 of Large Numbers | IBAN generate\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png\",\"width\":809,\"height\":604,\"caption\":\"Find MOD Manually - Divide Method\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calculate MOD of Large Numbers in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Calculate MOD of Large Numbers in Excel - Let's excel in Excel","description":"MOD of large numbers in excel | MOD calculation error for Big Numbers | VBA Function to calculate MOD of Big Numbers | MOD-97 of Large Numbers | IBAN generate","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:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Calculate MOD of Large Numbers in Excel","og_description":"MOD of large numbers in excel | MOD calculation error for Big Numbers | VBA Function to calculate MOD of Big Numbers | MOD-97 of Large Numbers | IBAN generate","og_url":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2024-02-02T14:52:51+00:00","og_image":[{"width":809,"height":604,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Calculate MOD of Large Numbers in Excel","datePublished":"2024-02-02T14:52:51+00:00","dateModified":"2024-02-02T14:52:51+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/"},"wordCount":850,"commentCount":4,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png","articleSection":["Excel Formula","Excel Functions","Excel Macro","Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/","url":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/","name":"Calculate MOD of Large Numbers in Excel - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png","datePublished":"2024-02-02T14:52:51+00:00","dateModified":"2024-02-02T14:52:51+00:00","description":"MOD of large numbers in excel | MOD calculation error for Big Numbers | VBA Function to calculate MOD of Big Numbers | MOD-97 of Large Numbers | IBAN generate","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2019\/02\/Find-Mod-Manually-1.png","width":809,"height":604,"caption":"Find MOD Manually - Divide Method"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/mod-of-big-numbers-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Calculate MOD of Large Numbers in Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/15054"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=15054"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/15054\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242618"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=15054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=15054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=15054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}