Excel Function : NOMINAL

Download now!

Excel Function : NOMINAL

Category

Financial

Description

Returns the annual nominal interest rate

Microsoft Excel Reference Page

https://support.office.com/en-us/article/NOMINAL-function-7f1ae29b-6b92-435e-b950-ad8b190ddd2b

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.