Menu
EXCEL NOMINAL FUNCTION
Excel NOMINAL Function Introduction
The Excel Nominal function calculates the nominal interest rate based on the effective interest rate is the amount of loading cycles per year.
Description of Excel NOMINAL Function
Syntax :
=NOMINAL( effect_rate, npery )
Parameters :
- The following are the arguments:
effect_rate –
- effect rate denotes the effective interest rate (a numerical value, between 0 and 1).
npery –
- The annual number of compound interest (must be a positive integer).
Step By Step Guide of NOMINAL Function
Example :
The Excel Nominal function is used in the following worksheet to determine the lending rate of three loans with varied terms.
Key Points
- #NUM! – Occurs if the specified effect rate is 0 or the supplied npery is 1.
- #VALUE! – This error occurs when one or both of the given parameters are non-numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
