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(number1, [number2], ...)
|number1, number2,...||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.|
Returns the least common multiple of integers.
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.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
|= LCM(5, 2)||Least common multiple of 5 and 2.||10|
|= LCM(24, 36)||Least common multiple of 24 and 36.||72|