Documentation/Calc Functions/ISODD ADD

    From The Document Foundation Wiki
    Other languages:


    Function name:

    ISODD_ADD

    Category:

    Information

    Summary:

    Determines whether a supplied number is even or odd. The sign of the number is ignored and if the value is not an integer, then any digits after the decimal separator are ignored. Returns the value 1 for an odd number, 0 otherwise.

    ISODD_ADD 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 ISODD function, those calls are converted to calls to the ISODD_ADD 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 ISODD_ADD function are converted to refer to the ISODD function.

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

    Note pin.svg

    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 ISODD function, which is compliant with ODF 1.2 and compatible with more recent versions of Excel.

    Syntax:

    ISODD_ADD(Number)

    Returns:

    -

    Arguments:

    -

    Additional details:

    -

    Examples:

    -

    Related LibreOffice functions:

    -

    ODF standard:

    -

    Related (or similar) Excel functions:

    -