The LCM function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.

LCM takes 1 required argument and 254 optional arguments:

Syntax: LCM(number1, [number2], ... )

#1)
Using the LCM function:
#2)
The arguments for the LCM function are:
Argument Required? Description
number1, number2, ... Required number1 is required, subsequent numbers are optional. 1 to 255 values for which you want the least common multiple. If value is not an integer, it is truncated.
#3)
A few more things:
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.

Summary

The LCM function returns the least common multiple of integers.
comments powered by Disqus