The NOMINAL function returns the annual nominal interest rate.

NOMINAL takes 2 required arguments and no optional arguments:

Syntax: NOMINAL(effect_rate, npery)

#1)
Using the NOMINAL function:
#2)
The arguments for the NOMINAL function are:
Argument Required? Description
effect_rate Required The effective interest rate
npery Required The number of compounding periods per year.
#3)
A few more things:
npery is truncated to an integer.
If either argument is nonnumeric, NOMINAL returns the #VALUE! error value.
If nominal_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value.
NOMINAL (effect_rate,npery) is related to EFFECT(nominal_rate,npery) through effective_rate=(1+(nominal_rate/npery))*npery -1.

Summary

The NOMINAL function returns the annual nominal interest rate.
comments powered by Disqus