Documentation/Calc Functions/LCM EXCEL2003

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

Other languages:

Calc Functions Home | List of functions | Abbreviations

Function name:

LCM_EXCEL2003

Category:

Mathematical

Summary:

Calculates the least common multiple (LCM) of a set of positive integers. The least common multiple is the smallest positive integer that is a multiple of all the given integer values.

LCM_EXCEL2003 exists only for interoperability with legacy documents created with older versions of Microsoft Excel. In Calc, if you open an Excel 2003 (.xls) file that contains calls to the LCM function, those calls are converted to calls to the LCM_EXCEL2003 function. If you save a document from Calc in ODS (Open Document Format for Office Applications) or OOXML (Office Open XML) format, any calls to the LCM_EXCEL2003 function are converted to refer to the LCM function.

Because of the limited applicability of this function, fuller details are intentionally omitted from this wiki.

Note:
For all new documents and most cases that do not require interoperability with legacy Excel spreadsheets, it is recommended that you use Calc's LCM function, which is compliant with ODF 1.2 and compatible with more recent versions of Excel.

Syntax:

LCM_EXCEL2003(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:

-

Arguments:

-

Additional details:

-

Examples:

-

Related LibreOffice functions:

-

ODF standard:

-

Related (or similar) Excel functions:

-