问题已解决
知道利率,怎么算等額本息,函數(shù)是那個
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
您好,PMT
例如:想問下貸款110萬三十年利率4.0等額本息 每個月應(yīng)該還多少?PMT (4%/12,360,1100000) 計算為5251.57
2023 09/18 14:06
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 15:27
PPMT,我想減去上月的在函數(shù)中怎么寫,按月支付,想知道每月的本金額
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 15:35
您好,這是等額本息,本金就是貸款除還款基數(shù)嘛
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 16:26
按這張表輸入時間自動跳轉(zhuǎn)下月月初,用哪個函數(shù)
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 16:27
我感覺我寫錯呢
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 16:29
您好,圖中我沒看明白,為啥借款是8.1,還款在1.1也有呀
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 16:30
沒有,就是現(xiàn)在只想讓日期跳轉(zhuǎn)到次月,其他可以先忽略
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 16:36
您好啊,這個新問題我不專業(yè),不好意思啊,我們答疑是一問一答的,辛苦您在問答區(qū)重新提問,謝謝您的理解。
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 16:41
感覺我這函數(shù)寫錯了
FAILED
FAILED
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 16:48
您好,這個函數(shù)前面沒有I的,是PMT
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 16:49
這個我寫了,他只有第一個月付利息么
FAILED
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 16:52
您好,我覺得您的公式里面好像不對呢??PMT (4%/12,360,1100000)?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 16:54
如果是兩年就是720天?
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 16:58
您好,這是月份數(shù)呀,2年是24月
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 17:07
我咋感覺不太對呢
FAILED
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 17:11
您好,是的,您的公式不對,PMT (月利率,還款月數(shù),貸款金額) ,后面還的0和1我也沒有看懂
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 17:13
PPMT這個函數(shù)怎么寫
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 17:23
您好,這個函數(shù)我沒有用過的,貸款函數(shù)用的就是PMT,不清楚的我不能隨便回答誤導(dǎo)您,請您原諒
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84785008 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/18 17:43
好的,謝謝啦老師
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/18 17:45
?親愛的,您太客氣了,祝您生活愉快!
![](/wenda/img/newWd/sysp_btn_eye.png)