Documentation/Calc Functions/NOMINAL ADD
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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.
Syntax:
NOMINAL_ADD(Effective rate; NPery)
Returns:
-
Arguments:
-
Additional details:
-
Examples:
-
Related LibreOffice functions:
-
ODF standard:
-
Related (or similar) Excel functions:
-