问题已解决
在EXCEL中 有文字有數(shù)字怎么用函數(shù)計(jì)算
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/95/80/16_avatar_middle.jpg?t=1651216848)
您好,如果一個(gè)單元格里有文字也有數(shù)字,要先將他們分離后,才能用函數(shù)
2021 03/11 08:41
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784965 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/11 08:42
怎么分離? 具體怎么操作
![](https://pic1.acc5.cn/011/95/80/16_avatar_middle.jpg?t=1651216848)
方麗老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 03/11 08:44
沒有看到你的表格
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784965 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/11 08:48
老師? 我在提問時(shí)發(fā)了一張紙? ? 拿總成本除以產(chǎn)量? ?產(chǎn)量在第一行? 有文字? 有數(shù)字
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784965 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/11 08:48
這是這一張表
FAILED
![](https://pic1.acc5.cn/011/95/80/16_avatar_middle.jpg?t=1651216848)
方麗老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 03/11 08:52
產(chǎn)量單獨(dú)列一行,不帶單位就可以
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784965 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/11 08:54
那怎么保證這個(gè)表格的完整性
![](https://pic1.acc5.cn/011/95/80/16_avatar_middle.jpg?t=1651216848)
方麗老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 03/11 08:59
加在合計(jì)列上一行,表格是完整的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784965 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/11 09:10
老師你能說細(xì)一點(diǎn)嗎? ?還不懂
![](https://pic1.acc5.cn/011/95/80/16_avatar_middle.jpg?t=1651216848)
方麗老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 03/11 09:13
你在電腦上輸入了表格了嗎
![](/wenda/img/newWd/sysp_btn_eye.png)