Returns the annual nominal interest rate for a given effective interest rate and number of compounding periods per year.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
NOMINAL(effect_rate, npery)The NOMINAL function calculates the nominal rate based on the effective annual rate. It is the inverse of the EFFECT function, allowing you to determine the base rate before compounding effects are applied.
=NOMINAL(0.0535, 4)Результат: 0.05245
Calculates the nominal rate for an effective rate of 5.35% compounded quarterly.
The nominal rate is the stated interest rate without compounding, while the effective rate accounts for the impact of compounding within the year.