Hàm Google Sheets

RATE

Returns the interest rate per period of an annuity.

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

RATE(nper, pmt, pv, [fv], [type], [guess])

The RATE function calculates the interest rate per period for a loan or investment by using an iterative method. It assumes constant payments and a constant interest rate throughout the duration of the annuity.

Đối số

nperbắt buộcThe total number of payment periods in an annuity.
pmtbắt buộcThe payment made each period, which cannot change over the life of the annuity.
pvbắt buộcThe present value, or the total amount that a series of future payments is worth now.

Ví dụ

=RATE(48, -200, 8000)

Kết quả: 0.0077

Calculates the monthly interest rate for a 48-month loan of 8000 with monthly payments of 200.

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

Why does the RATE function return a #NUM! error?

This usually happens if the function cannot find a result after 20 iterations, or if the provided arguments are mathematically impossible.

Hàm liên quan

NPER PMT PV FV