Edit

Share via


WorksheetFunction.Nominal(Object, Object) Method

Definition

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

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