O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

EFFECT()

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.

Arguments

  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required