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
- 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
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.