Exceljet

Quick, clean, and to the point

Excel GCD Function

Excel GCD function
Summary 

The Excel GCD function returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that goes into all supplied numbers without a remainder. For example, =GCD(60,36) returns 12.

Purpose 
Get the greatest common divisor of two or more numbers
Return value 
A number representing the largest positive integer that divides the numbers without a remainder
Syntax 
=GCD (number1, [number2], ...)
Arguments 
  • number1 - The first number.
  • number2 - [optional] The second number.
Usage notes 

Use the GCD function to get the greatest common divisor of two or more integers. The greatest common divisor is the largest positive integer that divides the numbers without a remainder. For example:

=GCD(60,36)

returns the number 12, since 12 is the largest factor that goes into both numbers evenly.

The GCD function can accept up to 255 numbers as arguments.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.