WorksheetFunction.Nominal(Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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 Double

Parameters

Arg1: Object

Effect_rate - the effective interest rate.

Arg2: Object

Npery - the number of compounding periods per year.

Returns

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

Applies to