How to Use GCD in Google Sheets in 2020?

GCDReturns 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