Syntax. NOMINAL(Effect_Rate,Npery)

Definition. This function calculates the nominal interest rate which (finance mathematically) leads to equivalence from a given effective interest rate.


  • Effect_Rate (required) The given effective annual interest rate, determined from the compound interest of an intra-annual yield.

  • Npery (required) The number of interest periods per year. If the Npery argument is a number with decimal places, it is truncated to an integer. The result must be greater than zero. Otherwise, NOMINAL() returns the error #NUMBER!. If one of the arguments is not a numeric expression or if Effect_Rate is not positive, NOMINAL() also returns the #NUMBER! error.

Background. For various financial transactions (such as mortgage ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.