LCM Function in Excel – Get the Least Common Multiple

LCM Function in Excel returns the Least Common Multiple of two or more supplied integers.

Syntax of LCM Function in Excel

LCM (number1, [number2], …)

 Where the number arguments are up to 255 numeric values for which you want to calculate the Least Common Multiple.

Example of LCM Function in Excel

Formula

LCM Function in Excel 1

  • Row number 2 to 4 Takes two Arguments
  • Row number 5 takes up three Arguments
  • In row number 6, Values are given directly instead of cell reference
Result

LCM Function in Excel 2

Note: #VALUE! Error occurs if the supplied number argument is non-numeric.

#NUM! Error occurs if any of the supplied number arguments are less than zero.

previous-small LCM Function in Excel                                                                                                           next_small LCM Function in Excel