GCD

Returns the greatest common divisor (GCD) of the specified sequence of numbers.

Syntax

GCD( Integer n1, [Integer n2], ... ) → Integer

Parameters

n1
n2
…

One or more numbers.

Remarks

If any of the specified arguments is negative, the function returns the #NUM! error value. If one of the arguments is a cell reference or an array, the values of the referenced cells or the array are included in the operation. If the specified values are not integer, they are automatically truncated.

Example

Formula

=GCD(12,18)
=GCD(7,3)

See Also

Function Reference
LCM Function