NOMINAL Function
Converts an effective annual rate into the quoted rate for a compounding frequency.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A nominal annual rate
Want to practice NOMINAL in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
NOMINAL is the reverse of EFFECT: given the true annual rate, it returns the quoted rate that compounds to it.
Divide the result by npery to get the rate per period to use in PMT or FV.
Syntax
=NOMINAL(effect_rate, npery) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| effect_rate | Yes | The effective annual rate. |
| npery | Yes | Compounding periods per year. |
Examples
Example 1 — Back to the quoted rate
A bank advertises 6.17% effective. What nominal rate is that?
C2fx=NOMINAL(6.17%,B2)
| A | B | C | |
|---|---|---|---|
| 1 | Compounding | Per year | Nominal rate |
| 2 | Monthly | 12 | 6.00% |
| 3 | Quarterly | 4 | 6.03% |
Common mistakes
- #NUM! error. effect_rate must be above 0 and npery at least 1.
Notes
- Related functions: EFFECT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.