Author: Oscar Cronquist Article last updated on September 04, 2018

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

Formula in cell D3:


Excel Function Syntax

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


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


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.