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.