Documentation/Calc Functions/EFFECT ADD

    From The Document Foundation Wiki
    Other languages:

    Function name:

    EFFECT_ADD

    Category:

    Financial Analysis

    Summary:

    Calculates an effective rate of interest based on a nominal interest rate, with interest credited and compounded multiple times during the period covered by the nominal interest rate.

    EFFECT_ADD performs a similar calculation to the EFFECT function. However, by default the value returned by EFFECT is formatted as a percentage whereas formatting is not applied to the value returned by EFFECT_ADD. Another minor difference is that for a nominal interest rate of 0%, EFFECT returns 0.00% while EFFECT_ADD reports an invalid argument error (Err:502).

    EFFECT_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 EFFECT function, those calls are converted to calls to the EFFECT_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 EFFECT_ADD function are converted to refer to the EFFECT 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 EFFECT function, which is compliant with ODF 1.2.

    Syntax:

    EFFECT_ADD(Nominal rate; Npery)

    Returns:

    -

    Arguments:

    -

    Additional details:

    -

    Examples:

    -

    Related LibreOffice functions:

    -

    ODF standard:

    -

    Related (or similar) Excel functions:

    -