LCM

The LCM function returns the least common multiple of a collection of number values.

LCM(num-value, num-value…)

num-value: A number value or a collection containing number values.

num-value…: Optionally include one or more additional numbers or collections of numbers.

Notes

Sometimes called the lowest or smallest common multiple, the least common multiple is the smallest integer that is a multiple of the specified numbers.

Examples
=LCM(2, 3) returns 6, the smallest number that is a multiple of both 2 and 3. =LCM(34, 68) returns 68, the smallest number that is a multiple of both 34 and 68. =LCM(30, 40, 60) returns 120, the smallest number that is a multiple of 30, 40, and 60. =LCM(30.25, 40.333, 60.5) returns 120 (the fractional parts are ignored). =LCM(2, -3) displays an error (negative numbers are not permitted).

Examples

=LCM(2, 3) returns 6, the smallest number that is a multiple of both 2 and 3.

=LCM(34, 68) returns 68, the smallest number that is a multiple of both 34 and 68.

=LCM(30, 40, 60) returns 120, the smallest number that is a multiple of 30, 40, and 60.

=LCM(30.25, 40.333, 60.5) returns 120 (the fractional parts are ignored).

=LCM(2, -3) displays an error (negative numbers are not permitted).