當(dāng)前位置:財(cái)稅問(wèn)題 >
財(cái)務(wù)軟件
問(wèn)題已解決
老師你好,怎么我在淘寶后臺(tái)下載的數(shù)據(jù)和支付寶后臺(tái)下載的數(shù)據(jù)怎么用IF(COUNTIF())函數(shù)顯示出來(lái)的結(jié)果是錯(cuò)誤的呢
![](https://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/000/12/54/40_avatar_middle.jpg?t=1651203186)
你先在電子表格中運(yùn)用函數(shù)的那列清除格式
2018 12/13 11:33
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/13 11:57
老師怎么清除格式呢
![](https://pic1.acc5.cn/000/12/54/40_avatar_middle.jpg?t=1651203186)
羅老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2018 12/13 13:20
選中那列,在開始菜單最右邊的有個(gè)清楚
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/13 13:56
格式清除了只顯示了一部分有一部分還是顯示不出來(lái)哦
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/13 13:57
有部分顯示出來(lái)是錯(cuò)誤的哦
![](https://pic1.acc5.cn/000/12/54/40_avatar_middle.jpg?t=1651203186)
羅老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2018 12/13 14:53
錯(cuò)誤的,檢查下條件是否正確或格式是否全部清除了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/14 13:56
檢查了,是不是文本格式所以才這樣的呢
![](https://pic1.acc5.cn/000/12/54/40_avatar_middle.jpg?t=1651203186)
羅老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2018 12/14 14:43
應(yīng)該是你的數(shù)字有文本格式的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/15 18:51
那老師有什么辦法解決嗎
![](/wenda/img/newWd/sysp_btn_eye.png)