WorksheetFunction.Nominal Method
Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Nominal ( _
Arg1 As Object, _
Arg2 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim returnValue As Double
returnValue = instance.Nominal(Arg1, Arg2)
double Nominal(
Object Arg1,
Object Arg2
)
Parameters
Arg1
Type: System.ObjectEffect_rate - the effective interest rate.
Arg2
Type: System.ObjectNpery - the number of compounding periods per year.
Return Value
Type: System.Double
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
.jpg "Equation")