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 returns the smallest positive [[Multiple]] of all the numbers.
* If any of the numbers are not whole numbers (or integers), then they are truncated.
* If any of the arguments are less than zero (negative), then #NUM! is returned.
* If any of the arguments are more than 2^53, then #NUM! is returned.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If the least common multiple is more than 2^53, then #NUM! is returned.
* This function can be used to add fractions with different denominators. (Example 12)
* 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(8, 12) = 24
2=LCM(8, 2) = 8
3=LCM(4, 8, 16, 20) = 80
4=LCM(15, 35, 60) = 420
5=LCM(5.9, 2.1) = 10
6=LCM(5, 2) = 10
7=LCM(6, 2) = 6
8=LCM(0, 0) = 0
9=LCM(-8, 16) = #NUM!
10=LCM(8, "some text") = #VALUE!
11=(1/4)+(2/6) = 0.5833
12=((1*LCM(4, 6)/4)/(4*LCM(4, 6)/4))+(2*LCM(4, 6)/(6*LCM(4, 6))) = 0.5833

1 - What is the least common multiple of 8 and 12.
2 - What is the least common multiple of 8 and 2.
3 - What is the least common multiple of 4, 8, 16 and 20.
4 - What is the least common multiple of 15, 35 and 60.
5 - What is the least common multiple of 5.9 and 2.1. Numbers that are not integers are truncated.
6 - What is the least common multiple of 5 and 2.
7 - What is the least common multiple of 6 and 2.
8 - What is the least common multiple of 0 and 0.
9 - Negative numbers that are passed as arguments generate an error.
10 - Text values that are passed as arguments generate an error.
11 - What is 1/4 add 2/6.
12 - What is 1/4 and 2/6.

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