LCM

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.