Returns the interest rate per period of an annuity.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
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.
=RATE(48, -200, 8000)ผลลัพธ์: 0.0077
Calculates the monthly interest rate for a 48-month loan of 8000 with monthly payments of 200.
This usually happens if the function cannot find a result after 20 iterations, or if the provided arguments are mathematically impossible.