WorksheetFunction.Nominal Method (Excel)
Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
Syntax
식 .Nominal(Arg1, Arg2)
식 A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
필수 |
Variant |
Effect_rate - the effective interest rate. |
Arg2 |
필수 |
Variant |
Npery - 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:
.gif "Ff197918.awfnomnl_ZA06051211(ko-kr,office.14).gif")