Syntax. EFFECT(Nominal_Interest,Periods)

Definition. This function calculates the equivalent effective annual interest yield (in arrears), also called the conform interest rate, from the nominal interest rate (in arrears) that is distributed to different periods of the same length within a year. Even though this is uncommon, a different time unit can also be substituted for the year.


  • Nominal_Interest (required) Returns the annual interest rate which, because of the distribution over the periods, is used for a respective intra-annual interest yield.

  • Periods (required) The number of interest days per year. This number is usually 2, 4, or 12.

Each argument must be evaluated as a number, otherwise, the #VALUE! error is displayed. The ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.