Formulas and functions > Functions from A to Z

Syntax:

LCM(Number1 [, Number2, Number3 ...])

Description:

This returns the LCM (least common multiple) of a set of numbers. The LCM is the smallest positive integer that is a multiple of the arguments.

You can specify numbers or cell references as arguments.

Number1, Number2, etc., are the numbers to be evaluated. All of them must be ≥ 1. Furthermore, only integers should be used. If this is not the case, Calculate automatically truncates the decimal places.

Example:

LCM(5, 10, 15) returns 30

If cells A1 to A3 contain the values 4, 8 and 6, the following shall apply:

LCM(A1:A3) returns 24