Documentation/Calc Functions/GCD EXCEL2003

    From The Document Foundation Wiki
    Other languages:

    Function name:





    Calculates the greatest common divisor (GCD) of a set of positive integers. The greatest common divisor is the largest positive integer that will divide, without remainder, each of the given integer values.

    GCD_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 GCD function, those calls are converted to calls to the GCD_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 GCD_EXCEL2003 function are converted to refer to the GCD function.

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

    Note pin.svg

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


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





    Additional details:




    Related LibreOffice functions:


    ODF standard:


    Equivalent Excel functions: