GCD (greatest common divisor)

<< Click to Display Table of Contents >>

GCD (greatest common divisor)

Syntax:

GCD(Number1 [, Number2, Number3 ...])

Description:

Returns the GCD (greatest common divisor) of the specified integers. The GCD is the largest integer that will divide all of the given integers without a remainder.

You can specify numbers or cell references as arguments.

Number1, Number2, etc., are the numbers to be evaluated. All of them have to be greater than zero. Additionally, all of them should be integers. Digits to the right of the decimal point are ignored.

Example:

GCD(25, 100, 250) returns 25

GCD(25, 105, 250) returns 5

If cells A1 to A3 contain the values 4, 8 and 6, respectively:

GCD(A1:A3) returns 2

See also:

LCM