LCM() Function

February 13, 2020
Number Function

The Excel LCM function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all supplied numbers.

Syntax

The Syntax for the LCM Formula is:

=LCM(number1,number2)

Function Arguments

number1 – Two or more numbers, separated by commas, or an array of numbers.

LCM Function Examples

The following spreadsheet shows four examples of the Excel Lcm Function.

Formulas:

Results:

Notes

  • If any argument is nonnumeric, LCM returns the #VALUE! error value.
  • If any argument is less than zero, LCM returns the #NUM! error value.
  • If LCM(a,b) >=2^53, LCM returns the #NUM! error value.
  • Number arguments are up to 255 numeric values
  • If any of the supplied numbers are decimals, these values are truncated to integers.