開始使用免費開始

Required fields for the PMT() function.

Within the PMT() function, there are 3 required fields to perform the calculation. Select the correct 3 from the list below.

These fields may be:

  • A) The opening balance of the loan.
  • B) The interest rate of the loan.
  • C) The length of the loan.
  • D) The amortization period of the loan.
  • E) The monthly principal payments on the loan.

本練習屬於課程

在 Google Sheets 進行貸款攤還

檢視課程

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習