Related Function:

The LCM function returns the least common multiple of two or more supplied integers.

Syntax

=LCM(num_1,[num_2], … )

Arguments

Argument Description
num_1,
[num_2], …
num_1 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

Examples

  A B D
1 Formula Result Notes
2 =LCM(1,5) 5 Least common multiple of 1 and 5
3 =LCM(15,10,25) 150 Least common multiple of 10, 15 and 25
4 =LCM(1,8,12) 24 Least common multiple of 1, 8 and 12
5 =LCM(7,2) 14 Least common multiple of 2 and 7
6 =LCM(“12”,5,10) #VALUE! One of the supplied number arguments is a text string
7 =LCM(-10,5,25) #NUM! One of the supplied number arguments is less than zero

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if one of the supplied number arguments is non-numeric
#NUM! Occurs if any of the supplied number arguments is less than zero