{"id":1225,"date":"2018-07-02T17:12:50","date_gmt":"2018-07-02T17:12:50","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1225"},"modified":"2023-11-03T09:07:53","modified_gmt":"2023-11-03T09:07:53","slug":"gcd","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/gcd\/","title":{"rendered":"GCD function"},"content":{"rendered":"\n<p>The Excel GCD function is used to find the greatest common divisor (GCD) of a set of numbers. In simpler terms, it helps you find the largest number that can evenly divide a group of numbers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>GCD(number1, [number2], &#8230;)<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<p>Here&#8217;s how the arguments work:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>number1<\/strong><\/td><td>The first number for which you want to find the GCD.<\/td><\/tr><tr><td><strong>number2<\/strong><\/td><td>(Optional) Additional numbers for which you want to find the GCD. You can include up to 255 numbers.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use<\/h2>\n\n\n\n<p>1. To use the GCD function, enter it in a cell where you want to calculate the GCD of a set of numbers. For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=GCD(A1, B1, C1)<\/code><\/pre>\n\n\n\n<p>2. Replace &#8220;A1,&#8221; &#8220;B1,&#8221; and &#8220;C1&#8221; with the cell references or numbers you want to find the GCD for.<\/p>\n\n\n\n<p>3. Press Enter, and Excel will calculate and display the GCD of the provided numbers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Examples<\/h2>\n\n\n\n<p>Let&#8217;s see some practical examples:<\/p>\n\n\n\n<p><strong>Example 1:<\/strong> Finding the GCD of 18 and 24<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=GCD(18, 24)<\/code><\/pre>\n\n\n\n<p>The result will be 6, as 6 is the largest number that can evenly divide both 18 and 24.<\/p>\n\n\n\n<p><strong>Example 2:<\/strong> Finding the GCD of multiple numbers<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=GCD(36, 48, 60)<\/code><\/pre>\n\n\n\n<p>In this case, the GCD is 12, which is the largest number that can evenly divide all three numbers.<\/p>\n\n\n\n<p><strong>Example 3:<\/strong> Using cell references<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=GCD(A1, B1, C1, D1)<\/code><\/pre>\n\n\n\n<p>If you have your numbers in cells A1, B1, C1, and D1, this formula will calculate the GCD for those cells.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Information<\/h2>\n\n\n\n<p>The GCD function is useful in various applications, such as simplifying fractions and solving mathematical problems where you need to find common divisors. It can be particularly handy in engineering, finance, and other fields where mathematical calculations are required.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Excel GCD function is used to find the greatest common divisor (GCD) of a set of numbers. In simpler terms, it helps&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GCD function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/gcd\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GCD function\" \/>\n<meta property=\"og:description\" content=\"The Excel GCD function is used to find the greatest common divisor (GCD) of a set of numbers. In simpler terms, it helps...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/gcd\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T17:12:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T09:07:53+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/gcd\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/gcd\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"GCD function\",\"datePublished\":\"2018-07-02T17:12:50+00:00\",\"dateModified\":\"2023-11-03T09:07:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/gcd\/\"},\"wordCount\":257,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/gcd\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/gcd\/\",\"name\":\"GCD function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-02T17:12:50+00:00\",\"dateModified\":\"2023-11-03T09:07:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/gcd\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/gcd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/gcd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GCD function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GCD function","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:\/\/officetuts.net\/excel\/functions\/gcd\/","og_locale":"en_US","og_type":"article","og_title":"GCD function","og_description":"The Excel GCD function is used to find the greatest common divisor (GCD) of a set of numbers. In simpler terms, it helps...","og_url":"https:\/\/officetuts.net\/excel\/functions\/gcd\/","article_published_time":"2018-07-02T17:12:50+00:00","article_modified_time":"2023-11-03T09:07:53+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/gcd\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/gcd\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"GCD function","datePublished":"2018-07-02T17:12:50+00:00","dateModified":"2023-11-03T09:07:53+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/gcd\/"},"wordCount":257,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/gcd\/","url":"https:\/\/officetuts.net\/excel\/functions\/gcd\/","name":"GCD function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-02T17:12:50+00:00","dateModified":"2023-11-03T09:07:53+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/gcd\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/gcd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/gcd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"GCD function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1225"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1225"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1225\/revisions"}],"predecessor-version":[{"id":16444,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1225\/revisions\/16444"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}