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.