Hàm Google Sheets

NOMINAL

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

Tạo công thức bằng AI Cùng hàm trong Excel

Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.

Cú pháp

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.

Đối số

effect_ratebắt buộcThe effective annual interest rate.
nperybắt buộcThe number of compounding periods per year.

Ví dụ

=NOMINAL(0.0535, 4)

Kết quả: 0.05245

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

Câu hỏi thường gặp

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.

Hàm liên quan

EFFECT RATE NPER