LCM() Function

The Excel LCM function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all supplied numbers.

Syntax

The Syntax for the LCM Formula is:

=LCM(number1,number2)

Function Arguments

number1 – Two or more numbers, separated by commas, or an array of numbers.

LCM Function Examples

 The following spreadsheet shows four examples of the Excel Lcm Function.

Formulas:

	A
1	=LCM( 1, 5 )
2	=LCM( 15, 10, 25 )
3	=LCM( 1, 8, 12 )
4	=LCM( 7, 2 )

Results:

	A
1	5
2	150
3	24
4	14

Notes

Ø  If any argument is nonnumeric, LCM returns the #VALUE! error value.

Ø  If any argument is less than zero, LCM returns the #NUM! error value.

Ø  If LCM(a,b) >=2^53, LCM returns the #NUM! error value.

Ø  Number arguments are up to 255 numeric values

Ø  If any of the supplied numbers are decimals, these values are truncated to integers.

References

http://www.excelfunctions.net/Excel-Lcm-Function.html

https://exceljet.net/excel-functions/excel-lcm-function

https://support.office.com/en-us/article/LCM-function-7152b67a-8bb5-4075-ae5c-06ede5563c94

http://www.automateexcel.com/functions/lcm-formula-excel

follow us on http://arivilm.blogspot.in

like us on https://www.facebook.com/Arivilm2501