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

Posted on:  08/30/2022

The GCD Function in Excel finds the Greatest Common Divisor. We will use GCD to show Ratios 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.

## 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.

## Recent Articles

#### 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.