Google Sheets işlevi

RATE

Returns the interest rate per period of an annuity.

Yapay zekâ ile formül oluştur Excel'deki aynı işlev

Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.

Söz dizimi

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.

Bağımsız değişkenler

nperzorunluThe total number of payment periods in an annuity.
pmtzorunluThe payment made each period, which cannot change over the life of the annuity.
pvzorunluThe present value, or the total amount that a series of future payments is worth now.

Örnekler

=RATE(48, -200, 8000)

Sonuç: 0.0077

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

SSS

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.

İlgili işlevler

NPER PMT PV FV