Formulas and functions > Functions from A to Z > GCD (greatest common divisor)

Syntax:

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

Description:

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

All given values Number1, Number2, etc., have to be greater than zero. Furthermore, only integers should be used. If this is not the case, Calculate automatically truncates the decimal places.

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, the following shall apply:

GCD(A1:A3) returns 2