WorksheetFunction.Nominal Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .Nominal(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Variant

Effect_rate - the effective interest rate.

Arg2

Required

Variant

Npery - the number of compounding periods per year.

Return Value

Double

  • 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: awfnomnl_ZA06051211

Show: