How to Use LCM in Google Sheets in 2020?

LCMReturns the least common multiple of one or more integers.

Sample Usage

LCM(A2:A5)

LCM(2,3,A4)

Syntax

LCM(value1, [value2, …])

value1 – The first value or range whose factors to consider in a calculation to find the least common multiple.

value2, … – [ OPTIONAL ] – Additional values or ranges whose factors to consider to find the least common multiple.

Notes

Any input with a decimal part provided to LCM will be silently truncated.

See Also

GCD: Returns the greatest common divisor of one or more integers.

Examples