Author: Oscar Cronquist Article last updated on May 04, 2022

The GCD calculates the greatest common divisor that divides all given arguments without a remainder.

Formula in cell D3:

=GCD(B3:B4)

Excel Function Syntax

GCD(number1, [number2], ...)

Arguments

number1 Required. A single numerical value or a cell reference to multiple numerical values.
[number2] Optional. Upp to 254 additional arguments.

Comments

The GCD function returns

  • #NUM! error value if any number is less than 0 (zero).
  • #VALUE! error value if any argument is not a numerical number.