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 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
Commenti e suggerimenti
https://aka.ms/ContentUserFeedback.
Presto disponibile: Nel corso del 2024 verranno gradualmente disattivati i problemi di GitHub come meccanismo di feedback per il contenuto e ciò verrà sostituito con un nuovo sistema di feedback. Per altre informazioni, vedereInvia e visualizza il feedback per