GCD

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.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!


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