WorksheetFunction.Nominal(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 nominal annual interest rate, given the effective rate and the number of compounding periods per year.
public:
double Nominal(System::Object ^ Arg1, System::Object ^ Arg2);public double Nominal (object Arg1, object Arg2);Public Function Nominal (Arg1 As Object, Arg2 As Object) As DoubleParameters
- Arg1
- Object
Effect_rate - the effective 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, Nominal returns the #VALUE! error value.
If effect_rate ≤ 0 or if npery < 1, Nominal returns the #NUM! error value.
Nominal is related to Effect(Object, Object) as shown in the following equation:
Figure 1: Equation