GCD

Returns the greatest common divisor of one or more integers.

Sample Usage

GCD(A2:A5)

GCD(24,96,A4)

Syntax

GCD(value1, [value2, ...])

  • value1 - The first value or range whose factors to consider in a calculation to find the greatest common divisor.

  • value2, ... - [ OPTIONAL ] - Additional values or ranges whose factors to consider to find the greatest common divisor.

Notes

  • Any input with a decimal part provided to GCD will be silently truncated.

See Also

LCM: Returns the least common multiple of one or more integers.

Examples

Was this helpful?
How can we improve it?