Contact
12 programs
Explore the site

NOMINAL_ADD in Collabora Office: Convert an Effective Annual Rate

Financial Intermediate Collabora Office Calc

Convert effective annual interest to a nominal compounding rate with the distinct NOMINAL_ADD compatibility function.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

Quick answer: =NOMINAL_ADD((1+8%/4)^4-1;4) has independently expected result 8%. It reverses quarterly compounding of a nominal annual rate. The _ADD suffix is part of this documented worksheet name.

Syntax and rate meaning

=NOMINAL_ADD(EffectiveRate; NPerY)

Both arguments are required. EffectiveRate is an effective annual rate stored as a decimal; enter 8% as 0.08 or with a percent sign. NPerY is the number of interest payments or compounding periods per year. Use a positive rate and a positive whole-number period count for these examples. Formulas use English names and semicolon separators.

For effective rate e and period count m, the independent nominal-rate calculation is m*((1+e)^(1/m)-1). Dividing this nominal annual rate by m yields the periodic rate. The effective rate is the full-year compounded growth, not simply m times the periodic rate.

Collabora documents suffixed _ADD and _EXCEL2003 names as compatibility functions corresponding to Excel 2003 functions without the suffix. Its separate NOMINAL guide concerns the unsuffixed function. Ordinary mathematical agreement does not justify replacing names or assuming identical invalid-input behavior.

Example 1: recover an eight-percent nominal rate

Enter =(1+8%/4)^4-1 in B2 and 4 in B3. The independently calculated effective annual rate in B2 is 0.08243216, or 8.243216%. Enter:

=NOMINAL_ADD(B2;B3)

In B5 this formula mathematically targets 0.08, displayed as 8%. Enter =B5/B3 in B6 for the quarterly periodic rate, 2%. Then enter =(1+B6)^B3-1 in B7: the independent target is the original 8.243216%.

Use B2’s formula-generated value rather than typing a rounded display back into the sheet. Keeping the complete effective rate makes this a clean inverse check. Dividing 8.243216% by four instead would not recover the quarterly compound rate.

Example 2: monthly compounding with an original control

Enter =(1+6%/12)^12-1 in D2 and 12 in D3. The independent effective annual rate is approximately 6.16778118645%. =NOMINAL_ADD(D2;D3) mathematically targets 6% nominal annually; dividing by twelve targets 0.5% monthly.

For a hypothetical opening amount of 2000 with no additional cash flows, =2000*(1+6%/12)^12 independently targets approximately 2123.355623729. Rebuilding the amount from the recovered nominal rate should target the same balance. This is an arithmetic compounding illustration, not a product quote or a statement about fees, taxes or contractual APR.

Example 3: understand the help’s rounded quarterly example

The official example uses =NOMINAL_ADD(5.3543%;4) and displays 0.0525, or 5.25%. Independent calculation from that rounded effective input gives approximately 0.052500319868356, or 5.250031986836%. The displayed help result is rounded, not exact equality at all decimal places.

For an exact mathematical inverse control, enter =NOMINAL_ADD((1+5.25%/4)^4-1;4). Its mathematical target is 5.25%, subject to ordinary finite-precision arithmetic in an actual implementation. Preserve the formula-generated effective rate to avoid converting a rounded input into a misleading precision assertion.

Boundaries and troubleshooting

With one annual period, the nominal and effective annual rates coincide mathematically: =NOMINAL_ADD(8%;1) targets 8%. The period count means periods per year, not the number of years or the total number of payments over a multiyear term. The returned nominal rate is annual; it still needs division by the period count to get a periodic rate.

The pinned add-in entry point receives an integer period count and rejects a nonpositive rate or a negative count before evaluating the formula. Its initial count guard is not the same as the unsuffixed core function’s guard: the add-in formula also divides by the count, so zero is not a valid worked example here. A source guard is not evidence for a particular user-visible error or successful acceptance of zero.

Fractional period input must pass through the add-in interface; do not import the core NOMINAL fractional-floor behavior as this function’s verified worksheet contract. Text coercion, blank cells, negative and zero rates, zero periods, overflow and exact error displays remain native-test questions. These limits qualify the claims, rather than prevent documentation-supported positive-integer examples.

Availability and evidence limits

The official help was retrieved on October 17, 2026; the saved page identifies Collabora Office 26.04 Help. Its archived bytes were reviewed on October 19, 2026. The /latest/ address may change. This article relies on that dated snapshot, not a claim that the help was freshly fetched or the function executed on October 19. First introduction and last functioning build are unknown; desktop documentation does not establish availability in every Online or mobile deployment.

The branch corroboration is pinned to c1013fad0d38683630b48c01b6d5208b8d81181e from the audited distro/collabora/co-26.04 branch. Registration and saved financial source were retrieved October 17; the name-construction/add-in implementation file was retrieved October 19, 2026. Source inspection is not an installed-product test.

No native Collabora execution occurred. Every worked numerical result is an independent mathematical expectation. No screenshots or application error observations are supplied. The guide does not establish all locale, coercion, array, export or extreme-value behavior. A native follow-up should record product edition, build and locale and compare the supplied small controls before relying on application-specific behavior.