Documentation/How Tos/Calc: LCM function

From Apache OpenOffice Wiki
Jump to: navigation, search


LCM

Returns the least common multiple of one or more integers.

Syntax:

LCM(integer1; integer2; ... integer30)

integer1 to integer30 are up to 30 integers or ranges of integers whose least common multiple is to be calculated.
The least common multiple (or lowest common multiple) is the smallest positive integer that is a multiple of all the given numbers.

Example:

LCM(4; 6)

returns 12, which is the smallest positive integer that is a multiple of 4 (12=4*3) and 6 (12=6*2).

LCM(B1:C1)

where B1 and C1 contain 6 and 3 respectively, returns 6.

Issues:

To comply with the ODFF standard, from OOo3.0 negative arguments to LCM will yield an error.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_LCM_function&oldid=243361"
Views
Personal tools
Navigation
Print/export
Tools