WorksheetFunction.Nominal (Excel)

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

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:

Nominal (Arg1, Arg2)

Dim dblNominal As Double
dblNominal = WorksheetFunction.Nominal(Arg1:=, Arg2:=)

Arguments

Arg1 - Effect_rate - the effective interest rate

Arg2 - Npery - the number of compounding periods per year