NOMINAL in Excel: Convert Effective Annual Rates to Nominal Quotes

=NOMINAL(effect_rate, npery)

Both arguments are required. Effect_rate is the annual rate after compounding; npery is the number of compounding periods per year. Microsoft documents integer truncation of npery.

The independent model is npery×((1+effect_rate)^(1/npery)−1). Taking a root first produces the periodic rate. Multiplication by the number of periods expresses the corresponding nominal annual quote.

An effective annual rate of 12.36% is equivalent to a nominal 12% compounded twice yearly:

=NOMINAL(12.36%,2)
=NOMINAL(12.36%,2)/2

Expected results are 12% annually and 6% per half-year. The second calculation explicitly divides the annual nominal output by the frequency.

Check independently that (1+6%)²−1=12.36%. Simply dividing the effective rate by two would produce 6.18%, which is not the equivalent periodic rate.

For effective annual 10%, compare:

=NOMINAL(10%,1)
=NOMINAL(10%,2)
=NOMINAL(10%,4)
=NOMINAL(10%,12)

Expected nominal annual percentages are approximately 10%, 9.761769634%, 9.645475634% and 9.568968515%. Their compounding conventions differ, but each reproduces the same 10% effective annual growth in this model.

A smaller nominal quote in this table is not a smaller effective annual rate. Comparing nominal rates without their frequencies can therefore be misleading.

Put effective annual 10% in B2 and frequency 12 in B3. In B4 use =NOMINAL(B2,B3). In B5 calculate =B4/B3.

The expected periodic monthly rate is about 0.797414043%. For an initial amount of 1000, =1000*(1+B5)^12 gives an expected 1100 after twelve modeled periods, before any fees, taxes or intermediate cash flows.

Keep the annual effective, annual nominal and periodic rates in separate labeled cells. They describe the same accumulation convention but are not interchangeable arguments in every financial function.

=EFFECT(NOMINAL(10%,12),12)

Expected result: 10%, within numerical tolerance. The period count must match in both functions. If the outer EFFECT uses four periods, the calculation no longer reverses the original conversion.

This control tests the conversion’s consistency, not a financial product’s advertised terms. An effective rate derived from a cash-flow calculation that incorporates fees may not be comparable to a quote that excludes them without further context.

Microsoft specifies #NUM! for effect_rate≤0 or npery<1, and #VALUE! for nonnumeric arguments. Although an algebraic zero-rate case can be written, NOMINAL(0,12) is a documented error case for this Excel function.

Npery is truncated. =NOMINAL(10%,12.7) therefore uses twelve periods under the documented rule. Supply an intentional whole number, because a fractional compounding-frequency input often signals a misunderstood unit rather than a useful calculation.

A result near 9.57 rather than 0.0957 can indicate entry or display confusion; percentages are stored as fractions. If a monthly model grows much too quickly, check whether the annual nominal result was used directly as a monthly rate. Divide it by the compounding frequency first.

This guide covers fixed positive rates and regular periods. It does not establish native Excel precision at extreme rates, blank-cell behavior or every coercion case. NOMINAL provides a rate conversion; it does not select a suitable financial product or calculate a fee-inclusive return from irregular cash flows.

• Current documentation: the dedicated Microsoft reference lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Introduced: the first introduction version/build is not established by the dedicated reference used here.
• Last functioning version: unknown; a current help listing is not a last-working-build test.
• Evidence checked: October 15, 2026. Official documentation was freshly retrieved; examples were independently calculated. No native Excel, Mac or web-client execution was performed.

• Microsoft NOMINAL reference.
• Microsoft function catalog and introduction-marker explanation.
• Editorial testing standards.

Examples use English function names and comma separators. Expected numbers are rounded independent mathematical calculations; documented error expectations are labeled as such. They are not captured Excel output. All illustrative data and policies are fictional.