Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .