LCM function

LCM(firstParameter, parameters...) LCM(firstParameter; parameters...)

firstParameter — Number or { Number }

The first parameter.

parameters — Number or { Number } (accepts many)

The remaining parameters.

Returns — Number

The least common multiple.

Returns the least common multiple of a set of numbers. LCM(4, 6)LCM(4; 6) returns 12, because 12 is the smallest positive integer that is a multiple of all parameters.

The parameters are expected to be integers, that is, they should not have fractional components. If they do, their numbers are truncated as though the INT function was applied to them.


LCM(30, 12)LCM(30; 12)

Returns 60.

LCM({ 24, 36 })LCM({ 24; 36 })

Returns 72.


Returns the least common multiple of the field values of the Field1:Field10Field1:Field10 range.

LCM(30, 12, 70)LCM(30; 12; 70)

Returns 420.