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

Teams Delete Chat

Teams Delete Chat

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

Excel Chart Maps used with the Geography Data Type

Excel Chart Maps used with the Geography Data Type

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Outlook Calendar - Meetings vs. Appointments

Outlook Calendar - Meetings vs. Appointments

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

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 Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories