LCM

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

Returns the least common multiple of two or more numbers.

number1The first number
number2(Optional) The second number.

REMARKS
* This function returns the smallest positive integer that is a multiple of all the numbers.
* This function can be used to add fractions with different denominators.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If any of the argument are less than one, then #NUM! is returned.
* If any of the numbers are not an integer, then they are truncated.
* You can have a maximum of 255 arguments.
* You can use the GCD function to return the greatest common divisor 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=LCM(5, 2) = 10
2=LCM(24, 36) = 72
3=LCM(24.9, 36.9) = 72
4=LCM(4, 6) = 12
5=(1/4)+(2/6) = 0.583
6=((1*LCM(4, 6)/4)/(4*LCM(4, 6)/4))+(2*LCM(4, 6)/(6*LCM(4, 6))) = 0.583
7=LCM("some text", 36) = #VALUE!
8=LCM(24, "some text") = #VALUE!


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