问题已解决
為什么單元格設(shè)置的保留兩位小數(shù) 往下拉合計(jì)時(shí)還是有好幾位小數(shù)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/16/05/25_avatar_middle.jpg?t=1651203962)
您好,很高興為您解答問(wèn)題!
正常不會(huì)出現(xiàn)這種情況的,你重新設(shè)置單元格格式--數(shù)值-- 或者用圖片所示功能。
FAILED
FAILED
2019 06/25 09:01
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784963 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 06/25 09:24
沒(méi)用 我最終合計(jì)時(shí)還是好多位小數(shù)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784963 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 06/25 09:25
round函數(shù)怎么用
![](https://pic1.acc5.cn/010/16/05/25_avatar_middle.jpg?t=1651203962)
曉宇老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 06/25 09:32
用ROUND函數(shù)保留兩位小數(shù)點(diǎn)。=ROUND(A2,2)
![](/wenda/img/newWd/sysp_btn_eye.png)