Excel Function : NOMINAL

Download now!

Excel Function : NOMINAL




Returns the annual nominal interest rate

Microsoft Excel Reference Page


Syntax and Description of the NOMINAL Excel Function

dna The syntax for the NOMINAL function in Excel is as follows: =NOMINAL(rate,nper) where "rate" is the interest rate per period and "nper" is the number of periods.

About NOMINAL Excel Function

NOMINAL(rate, npery) This function returns the nominal interest rate for a given effective interest rate and number of compounding periods per year.