LCM

Using the Excel LCM Function

Summary

The LCM function returns the least common multiple (LCM) of an integer. The least common multiple is the smallest positive integer that is a multiple of all integer arguments passed to the function.

Syntax

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

Syntax Breakdown

number1
The number1 argument is required and is the number for which you want to find the LCM.

[number2]
The number2 and any subsequent arguments are optional. The LCM function can handle up to 255 values. Any non-integer numbers are truncated.


Usage Notes

The LCM function returns the least common multiple of integers supplied by the user. The LCM function is commonly used to add fractions with different denominators. The function can accept up to 255 values. A similar function, GCD, returns the greatest common divisor of two or more integers.

LCM Errors
If any argument is non-numeric the function will return the #VALUE! error.

Excel LCM VALUE Error

If any argument is less than zero the function will return the #NUM! error.

Excel LCM NUM Error