WorksheetFunction.Effect Method
Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Effect ( _
Arg1 As Object, _
Arg2 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim returnValue As Double
returnValue = instance.Effect(Arg1, Arg2)
double Effect(
Object Arg1,
Object Arg2
)
Parameters
Arg1
Type: System.ObjectNominal_rate - the nominal interest rate.
Arg2
Type: System.ObjectNpery - the number of compounding periods per year.
Return Value
Type: System.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:
Figure 1: Equation for calculating Effect method
.jpg "Equation for calculating Effect method")