이 함수는 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.