NOMINAL function
NOMINAL converts an effective yearly interest rate back to the quoted nominal rate for a given number of compounding periods per year. It is the reverse of EFFECT.
Example
Read it as a sentence: work out the nominal yearly rate that gives an effective 6% a year when compounded 12 times a year, which gives 0.0584106067841166.
A
B
C
D
1
0.0584106067841166
2
3
Syntax
NOMINAL(effect_rate, npery)
-
effect_rate(required) - Effective annual rate.
-
npery(required) - Compounding periods per year (whole number).
Returns: Stated annual rate that compounds to the effective rate.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=NOMINAL(0.0512,12) | 0.050036398 | Effect 5.12% |
=NOMINAL(0.05,1.5) | 0.05 | Npery 1.5 |
=NOMINAL("0.05","12") | 0.048889485 | Text number |
=NOMINAL({0.05,0.1},12) | 0.048889485 | Spill |
=NOMINAL(0.05,0) | #NUM! | Npery 0 |
=NOMINAL(0,12) | #NUM! | Effect 0 |
=NOMINAL(-0.05,12) | #NUM! | Effect negative |
=NOMINAL("a",12) | #VALUE! | Text |
Watch out for
- npery is truncated to a whole number.
Where it works
- Excel
- NOMINAL is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .