WorksheetFunction.Effect(Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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 Double

Parameters

Arg1: Object

Nominal_rate - the nominal interest rate.

Arg2: Object

Npery - the number of compounding periods per year.

Returns

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

Applies to