Article updated on February 27, 2018

The LCM function calculates the least common multiple. The least common multiple is the smallest positive integer that is a multiple of all integer arguments. Use the LCM function to find fractions with different denominators.

Formula in cell B3:


Excel Function Syntax

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


number1 Required. The number you want to calculate the least common multiple for.
[number2] Optional. Up to 254 additional numbers.


The LCM function returns an error value if any argument is not a number.