Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
expression . Gcd( Arg1 , Arg2 , Arg3 , Arg4 , Arg5 , Arg6 , Arg7 , Arg8 , Arg9 , Arg10 , Arg11 , Arg12 , Arg13 , Arg14 , Arg15 , Arg16 , Arg17 , Arg18 , Arg19 , Arg20 , Arg21 , Arg22 , Arg23 , Arg24 , Arg25 , Arg26 , Arg27 , Arg28 , Arg29 , Arg30 )
expression A variable that represents a WorksheetFunction object.
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 - Arg30 | Required | Variant | Number1, number2, ... - 1 to 29 values. If any value is not an integer, it is truncated. |
Double
-
If any argument is nonnumeric, GCD returns the #VALUE! error value.
-
If any argument is less than zero, GCD returns the #NUM! error value.
-
One divides any value evenly.
-
A prime number has only itself and one as even divisors.