NOMINAL Function
Calculates the nominal annual interest rate from an effective rate.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| effect_rate | Effective annual interest rate. | Required |
| npery | Number of compounding periods per year. | Required |
Basic Example
Nominal rate from an effective annual rate
=NOMINAL(0.0617, 12)An effective annual rate of 6.17% with monthly compounding corresponds to a 6% nominal rate.
Advanced Examples
Example 1: Annual percentage rate calculation
Loan disclosureFind the nominal APR from an effective rate
=NOMINAL(0.08, 12)How NOMINAL Works
NOMINAL is the inverse of EFFECT. It computes the nominal rate that, when compounded npery times per year, produces the given effective annual rate.
Important Notes & Limitations
Requires npery >= 1.
Result is the nominal annual rate, not the periodic rate.
Common Errors & Fixes
#NUM! errornpery is less than 1 or effect_rate is invalid.Fix: Ensure npery >= 1 and effect_rate is a positive decimal.
Wrong rateEffective rate was entered as a percentage instead of a decimal.Fix: Enter 0.0617 for 6.17%, not 6.17.
Download Practice File
NOMINAL
nominalPractice NOMINAL with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the NOMINAL function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps