Returns the annual nominal interest rate for a given effective interest rate and number of compounding periods per year.
이 함수는 Google Sheets에서도 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.