NOMINAL()
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.
Arguments
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
