Manuals/calci/NOMINAL
NOMINAL(ER, nper)
Where 'ER'is the effective interest rate and 'nper' is the number of compounding periods per year.
This function calculates the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
- NOMINAL shows the error value. When either argument is nonnumeric or ER ≤ 0 or nper <1
- NOMINAL is shown in the following equation:
NOMINAL
Lets see an example,
NOMINAL(ER, nper)
B
6.234%
5
=NOMINAL(B2,B3) is 0.0608
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 6.234% | |||
| Row2 | 5 | |||
| Row3 | 0.060841 | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
