INFO
This page was originally generated from official documentation.
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
Sample Usage
NOMINAL(0.85,12)
NOMINAL(A2,A3)Syntax
NOMINAL(effective_rate, periods_per_year)effective_rate- The effective interest rate per year.periods_per_year- The number of compounding periods per year.
See Also
INTRATE: Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.
EFFECT: Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.