WorksheetFunction.Nominal method (Excel)
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.
| 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. |
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:
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.