Edit

Share via


WorksheetFunction.Effect(Object, Object) Method

Definition

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

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