Collapse the table of content
Expand the table of content
Expand Minimize

WorksheetFunction.Effect Method (Excel)

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

expression .Effect(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Variant

Nominal_rate - the nominal interest rate.

Arg2

Required

Variant

Npery - the number of compounding periods per year.

Return Value

Double

  • 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: awfefect_ZA06051135

Show:
© 2015 Microsoft