Documentation/Calc Functions/NOMINAL ADD

    From The Document Foundation Wiki
    Other languages:

    Function name:

    NOMINAL_ADD

    Category:

    Financial Analysis

    Summary:

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

    NOMINAL_ADD performs a similar calculation to the NOMINAL function. However, by default the value returned by NOMINAL is formatted as a percentage whereas formatting is not applied to the value returned by NOMINAL_ADD.

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

    Syntax:

    NOMINAL_ADD(Effective rate; NPery)

    Returns:

    -

    Arguments:

    -

    Additional details:

    -

    Examples:

    -

    Related LibreOffice functions:

    -

    ODF standard:

    -

    Related (or similar) Excel functions:

    -