Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
NOMINAL
NOMINAL is the inverse of EFFECT: given an effective annual rate and compounding frequency, it returns the nominal annual rate that would produce it. Use it when you need to quote a nominal rate that matches a required effective yield.
Excel
=NOMINAL(0.1268,12)Google Sheets
=NOMINAL(0.1268,12)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Effective Rate | Periods/Year |
| 0.1268 | 12 |
| 0.1038 | 4 |
| 0.0609 | 2 |
| 0.0833 | 365 |
=NOMINAL(0.1268,12)→0.1199775647
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the desired effective annual rate and the number of compounding periods per year.
- 2Enter =NOMINAL(effect_rate, npery) to get the corresponding nominal rate.
- 3Use the result for quoting rates in loan agreements or product disclosures.
Need a version for your data?
Try: “What nominal rate compounded monthly produces an effective annual rate of 12.68%?”