Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

WorksheetFunction.Effect Method

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

Syntax

expression.Effect(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantNominal_rate - the nominal interest rate.
Arg2RequiredVariantNpery - the number of compounding periods per year.

Return Value
Double

Remarks

  • Npery is truncated to an integer.
  • If either argument is nonnumeric, EFFECT returns the #VALUE! error value.
  • If nominal_rate ≤ 0 or if npery < 1, EFFECT returns the #NUM! error value.
  • EFFECT is calculated as follows:

    Equation




Community Additions

Show: