Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Financial > NOMINAL
 

NOMINAL(effect_rate, npery)

 
 Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.

 effect_rateThe effective interest rate.
 nperyThe number of compounding periods per year.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• "npery" is truncated to an integer.
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If "effect_rate" = 0, then #NUM! is returned.
     
  		• If "npery" < 1, then #NUM! is returned.
     
  		• This function is related to the EFFECT() function.

     EXAMPLES
     
     A
    1=NOMINAL(5.3543%,4) = 0.053
    2=NOMINAL(15/100,4) = 0.142
    3=NOMINAL(15/100,1) = 0.15
    4=NOMINAL(15/100,-1) = #NUM!
    5=NOMINAL("some text",4) = #VALUE!
    		 
     Functions - N | Index - N | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top