Using the Excel LCM Function
SummaryThe 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], ...)
The number1 argument is required and is the number for which you want to find the LCM.
The number2 and any subsequent arguments are optional. The LCM function can handle up to 255 values. Any non-integer numbers are truncated.
Usage NotesThe 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.
If any argument is non-numeric the function will return the #VALUE! error.
If any argument is less than zero the function will return the #NUM! error.