→ newacc: 或用連加的公式n x (n+1)/211/11 22:12
※ 編輯: CoffeeMoon (36.231.103.116), 11/12/2018 05:34:12
→ wxtab019: FACT(n) 11/13 21:22
→ wxtab019: 阿 看錯 11/13 21:23
→ wxtab019: 用上面公式吧 =SUMPRODUCT(ROW(INDIRECT("1:n"))) 11/13 21:26
→ wxtab019: 用excel的公式還比較長一串 11/13 21:26
推 mini5269: 用PMT函數計算含利息每期應付款的金額,再乘上期數,接 12/09 13:06
→ mini5269: 著減去原貸款金額,剩下的就是付的利息!=PMT(1%/12,4,8 12/09 13:06
→ mini5269: 000)*4+8000 12/09 13:06
→ mini5269: =PMT(1%/12,4,8000)+8000 12/09 13:07