NOMINAL_ADD Function (LibreOffice Calc)

• Introduced: First release not established; documented by LibreOffice 3.3.
• Supported in: Documented in LibreOffice 26.8 Help and registered in 26.8.1.1. No retirement is established.
• Scope: Desktop Calc, English compatibility function name and semicolon-separated formulas. A suffix does not by itself mean deprecated or retired.
• Checked: October 14, 2026. Eight reference calculations and the function-specific documentation were checked. Complete financial wrapper guards were not inspected. No native execution is claimed.

NOMINAL_ADD returns a nominal annual rate that compounds to the supplied effective annual rate at the specified frequency. It is the Analysis add-in counterpart of the separately registered core NOMINAL function. Function-specific Help.

LibreOffice’s documentation describes _ADD names as compatibility variants associated with Excel 2003 behavior and recommends the unsuffixed functions for standards-oriented results. Keep the exact original function name when evaluating an imported workbook.

=NOMINAL_ADD(EffectiveRate;Periods)

• EffectiveRate: effective annual interest rate as a decimal.
• Periods: number of equal compounding periods per year.

Both arguments are required. Use positive effective rates and positive integer frequencies for the ordinary reference model. This guide does not establish zero or fractional period handling.

These references use the annual compounding relationship. Noninteger values are displayed to twelve decimal places; intermediate calculations retain greater precision.

An effective annual 12% with monthly compounding corresponds to nominal annual rate approximately 0.113865515215, or 11.3865515215%. Dividing that nominal quote by twelve gives the monthly rate. It is smaller than 12% because compounding supplies the rest of the annual growth.

For two periods the nominal rate is approximately 0.116601048852. With one period it is exactly the original 12%. These results answer a different question from EFFECT_ADD(0.12;12), which starts with a nominal 12% rather than an effective 12%.

The independent formula is m*((1+effective)^(1/m)-1). Raising 1+nominal/m to the power m recovers 1+effective. This round-trip is a useful check of which annual rate the original input represents.

For positive effective e, as m increases the nominal quote approaches LN(1+e). That limit is independent mathematics, not an execution claim for an extreme period count. Keep enough precision in the nominal rate before converting it back; a displayed percentage rounded to two decimals will not generally reproduce the original effective value exactly.

The mathematical inverse divides by the period count, so the worked model explicitly uses a positive count. All eight references also use positive effective rates. No zero-period result, error display or special endpoint is asserted.

The current financial worksheet wrapper was not inspected. Exact conversion of fractional counts, text, blanks or extreme values, and its complete validation rules, remain unverified. A nominal-rate conversion by itself does not calculate the annualized cost of a loan with fees or irregular dated payments. Preserve the intended compounding convention and full input precision.

NOMINAL, EFFECT, RATE.

• Function-specific Help and compatibility note
• Versioned Analysis add-in registration

The references establish the documented ordinary model. Native execution, exceptional-input behavior and cross-product equivalence remain unverified.