This documentation is archived and is not being maintained.

WorksheetFunction.Nominal Method

Office 2007
Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.

Syntax

expression.Nominal(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantEffect_rate - the effective interest rate.
Arg2RequiredVariantNpery - the number of compounding periods per year.

Return Value
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 as shown in the following equation:

    Equation




Show: