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

Returns the greatest common divisor of two or more numbers.

number1The first number.
number2(Optional) The second number.

Remarks

* This function returns the largest positive integer that can divide all the numbers without a remainder.
* If any of the numbers are not an integer, then they are truncated.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If any argument is less than zero, then #NUM! is returned.
* One divides any value evenly ??
* A prime number has only itself and one as even divisors.
* You can have a maximum of 255 arguments.
* You can use the LCM function to return the least common multiple of two or more numbers.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=GCD(5,2) = 1
2=GCD(1,50) = 1
3=GCD(50,2) = 2
4=GCD(24,36) = 12
5=GCD(7,1) = 1
6=GCD(5,0) = 5
7=GCD(10.5,2.6) = 2
8=GCD(2.6,10.5) = 2
9=GCD(5,-0.5) = #NUM!
10=GCD("some text",0.5) = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top