问题已解决
某公司購進(jìn)一臺(tái)設(shè)備,設(shè)備原值600 000元,預(yù)計(jì)使用6年,預(yù)計(jì)凈殘值為30 000元,利用Excel函數(shù),分別按平均年限法、年數(shù)總和法和雙倍余額遞減法計(jì)提折舊。
![](https://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/08/79/95_avatar_middle.jpg?t=1733968385)
你好,這里是涉及函數(shù)計(jì)算嗎?
2020 05/18 17:07
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:08
對
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:08
就是要用Excel做的
![](https://pic1.acc5.cn/010/08/79/95_avatar_middle.jpg?t=1733968385)
暖暖老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 05/18 17:09
會(huì)計(jì)分錄和數(shù)字都寫出來填上?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:09
嗯
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:10
這種格式
FAILED
![](https://pic1.acc5.cn/010/08/79/95_avatar_middle.jpg?t=1733968385)
暖暖老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 05/18 17:13
你把截圖發(fā)的大一些,我填寫上拍給你
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:18
老師,謝謝您了,這個(gè)時(shí)間到了已經(jīng)交了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:18
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:18
但我想知道正確結(jié)果
![](https://pic1.acc5.cn/010/08/79/95_avatar_middle.jpg?t=1733968385)
暖暖老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 05/18 17:19
我接著做發(fā)給你,稍等
![](https://pic1.acc5.cn/010/08/79/95_avatar_middle.jpg?t=1733968385)
暖暖老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 05/18 17:31
我做的明細(xì)表你看看
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:31
謝謝老師了
![](https://pic1.acc5.cn/010/08/79/95_avatar_middle.jpg?t=1733968385)
暖暖老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 05/18 17:32
不客氣,麻煩給予五星好評
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784989 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 05/18 17:35
好的
![](https://pic1.acc5.cn/010/08/79/95_avatar_middle.jpg?t=1733968385)
暖暖老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 05/18 17:38
祝你新隵開心愉快
![](/wenda/img/newWd/sysp_btn_eye.png)