Lcm

Syntax

Lcm(Values1, …)

Values1, Values2, …, ValuesN. Cell range, for the values of which you need to find the lowest common denominator.

It returns the least common multiple for two or more integers.

Formula	Result	Description
=Lcm(B6:E6)	84	The lowest common denominator for the numbers from the cell range between B6 and E6. This range contains the following numbers: 21, 7, 14, 28.