WorksheetFunction.Effect(Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
public:
double Effect(System::Object ^ Arg1, System::Object ^ Arg2);public double Effect (object Arg1, object Arg2);Public Function Effect (Arg1 As Object, Arg2 As Object) As DoubleParameters
- Arg1
- Object
Nominal_rate - the nominal interest rate.
- Arg2
- Object
Npery - the number of compounding periods per year.
Returns
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:
Figure 1: Equation for calculating Effect method