Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

Posted on:  08/30/2022
Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

The GCD Function in Excel finds the Greatest Common Divisor. We will use GCD to show Ratios in Excel.

GCD Function in Excel

GCD Function in Excel

GCD finds the greatest common divisor, which is an integer, and it will divide into the numbers without a remainder.

Examples of GCD function

  1. The GCD of the three numbers 10, 50, and 100 is 10.
  2. The GCD of 7, 35, and 70 is 7.
  3. The GCD of 7, 9, and 70 is 1. Seven will go into 7 and 70 but not in 9 without a remainder.
  4. The GCD of 64 and 144 is 16. Sixteen goes into both 64 and 144.
Word Articles

YouTube Video of GCD Function

Chapters

  • 0:00 Intro
  • 0:24 GCD Function
  • 1:10 Ratios using GCD

How to use GCD to calculate ratios

To calculate rations using GCD, take the numerator and divide by the GCD of both numbers Next take the denominator and divide by the GCD of both numbers.

Ratio calculation using GCD

Ratio calculation using GCD

Recent Articles

NEW Teams  - Two New Features - October 2023

NEW Teams - Two New Features - October 2023

EA Ignite Fall 2023 - San Antonio TX - Chris Menard - Two Sessions

EA Ignite Fall 2023 - San Antonio TX - Chris Menard - Two Sessions

April 6, 2024 - Excel Training for MBA Students from the University of Georgia

April 6, 2024 - Excel Training for MBA Students from the University of Georgia

Excel - Advanced Filters

Excel - Advanced Filters

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Analyze Results from Microsoft FORMS POLLS in Excel  | Watch Chris Work

Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

MS Forms - 3 new features: Format surveys, send to specific users, and receipt

MS Forms - 3 new features: Format surveys, send to specific users, and receipt

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 18 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at chrismenardtraining.com/linked or watch his videos on YouTube at chrismenardtraining.com/youtube.

Categories