GCD Function in Excel- Get the Greatest Common Divisor

GCD Function in Excel returns the greatest common divisor of two or more supplied integers.

Syntax of GCD Function in Excel

GCD (number1, [number2], …)

Where the number arguments are up to 255 numeric values for which you want to calculate the greatest common divisor.

Example of GCD Function in Excel

Formula

GCD Function in Excel 1

  • Row number 2 to 4 Takes two Arguments
  • Row number 5 takes up three Arguments
  • In Row number 6, Values are given directly instead of cell reference

So the output will be

Example

GCD Function in Excel 2

Note: #VALUE! Error occurs if the supplied number argument is non-numeric.

#NUM! Error occurs if any of the supplied number arguments are less than zero.

previous-small GCD Function in Excel                                                                                                           next_small GCD Function in Excel