<< Click to Display Table of Contents >> 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, PlanMaker automatically truncates the decimal places.

Example:

GCD(25, 100, 250) returns 25

GCD(25, 105, 250) returns 5

If A1:A3 contains the values 4, 8 and 6, the following applies:

GCD(A1:A3) returns 2

See also:

LCM