Funzione di Google Sheets

NOMINAL

Returns the annual nominal interest rate for a given effective interest rate and number of compounding periods per year.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

effect_rateobbligatorioThe effective annual interest rate.
nperyobbligatorioThe number of compounding periods per year.

Esempi

=NOMINAL(0.0535, 4)

Risultato: 0.05245

Calculates the nominal rate for an effective rate of 5.35% compounded quarterly.

Domande frequenti

What is the difference between nominal and effective rates?

The nominal rate is the stated interest rate without compounding, while the effective rate accounts for the impact of compounding within the year.

Funzioni correlate

EFFECT RATE NPER