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
- 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
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.