00:10:00
问题已解决
老师，我想问下这一个单元格如何能把里面的"工程地点"和"姓名"分开呢？
温馨提示：如果以上题目与您遇到的情况不符，可直接提问，随时问随时答
光标定位到 地点的点字后面，按 alt + enter强制换行即可
2019 08/10 15:53
阅读 594 温馨提示：如果以上题目与您遇到的情况不符，可直接提问，随时问随时答 阅读 594
描述你的问题，直接向老师提问相关问答
查看更多-
=acct("","1401:1411","Y",0,0,0,0,"GLC","Company")+acct("","1421","Y",0,0,0,0,"GLC","Company")+acct("","1431","Y",0,0,0,0,"GLC","Company")-acct("","1471","Y",0,0,0,0,"GLC","Company")+acct("","5401","Y",0,0,0,0,"GLC","Company")+acct("","
22 -
如图，已知姓名对应的性别，当想节省时间，每次录入姓名，如何让性别列自动跳出是"男"还是"女"？
1516
-
老师好，有一个表格
"张三 虹口区" "张三”
"李四 黄浦区" "李四”
"王五 长宁区" "王五”
……
老师好，怎么用Excel函数获得虹口区
黄浦区
长宁区
非常感谢，
1104
-
IF($A8="华美达","月结","现结",IF($A8="皇尊酒店","月结","现结",IF($A8="星湖KTV","月结","现结",IF($A8="维也纳音乐会所","月结","现结",IF($A8="金色港湾音乐会所","月结","现结",IF($A8="凯都会大酒店","月结","现结",IF($A8="新星湖KTV(金星湖）","月结","现结",IF($A8="*"&恒晟超市&"*","月结","现结"))))))))
显示公式错误，是错哪呢
893
-
=acct("","1122.01|00001|","JY",0,0,0,0,"BB01")+acct("","1122.02","Y",0,0,0,0,"BB01")-acct("","1231.01","Y",0,0,0,0,"BB01") 老师， 这个bb01是什么意思啊
1400
赶快点击登录
获取专属推荐内容
意见反馈
