Returns the least common multiple of one or more integers.
Sample Usage
LCM(5,4)
LCM(C5:C7)
Syntax
LCM(value1, [value2,..])
- value1 - The first number or range to consider while calculating LCM.
- value2,.. - [OPTIONAL] Additional numbers or ranges to calculate for the LCM.
Examples
LCM(5,4) returns 20, which is the least common multiple of 5 and 4.
LCM(C5:C7) returns the least common multiple of the numbers in the range C5:C7.
Notes
- Decimal inputs will be truncated.
- If any argument is nonnumeric, LCM returns the #VALUE! error value.
- If any argument is less than zero, LCM returns the #NUM! error value.