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

Returns the least common multiple of two or more numbers.

number1The first number
number2(Optional) The second number.

* 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

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!

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