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.