問題已解決
pv函數(shù)計(jì)算現(xiàn)值,期數(shù)怎么計(jì)算(比如202101 和202112)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
同學(xué)您好,可以用DATEDIF(202101 ,202112,M)可以計(jì)算期數(shù)的
2022 09/19 09:44
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/19 10:01
怎么嵌入pv函數(shù)?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/19 10:02
而且我是年利率
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/19 10:02
有四個(gè)參數(shù),放第二個(gè)參數(shù)位置
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/19 10:10
但是datedif求職 結(jié)果不對(duì) 出不來值
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/19 10:11
是不是沒有日期的原因?
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/19 10:57
是的沒錯(cuò),填上日期再試
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/19 11:00
求年的時(shí)候 無法精確到小數(shù)點(diǎn) 這個(gè)怎么辦
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/19 11:37
一般是處理整數(shù)期數(shù)的,精確到月或天數(shù)試試
![](/wenda/img/newWd/sysp_btn_eye.png)