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.
* 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=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!


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