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

Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings

Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings

Teams - Change your status in Teams | Duration and Status Message

Teams - Change your status in Teams | Duration and Status Message

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

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

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

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