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 are considered 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.