老师好，有一个表格 "张三虹口区" "张三” "李四黄浦区" "李四” "王五长宁区" "王五” …… 老师好，怎么用Excel函数获得虹口区黄浦区长宁区非常感谢，_Excel_财税问答-正保会计网校(原中华会计网校)_手机版

问题已解决

所属话题：

老师好，有一个表格 "张三虹口区" "张三” "李四黄浦区" "李四” "王五长宁区" "王五” …… 老师好，怎么用Excel函数获得虹口区黄浦区长宁区非常感谢，

84784982 | 提问时间：2022 10/13 09:45

小林老师

金牌答疑老师

职称：注册会计师,中级会计师,税务师

您好，麻烦发下图片看下

2022 10/13 09:48

7条追问解答查看全部

结果不满意？专业老师答疑，提问更省心立即提问

相关问答

=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

=IF(F2>30,"算","不算")为什么我用这个函数算出来的不准呢？

38

=IF(F4="","",VLOOKUP(F4,库存表!C:C,1,0)) =IF(F3="","",IF(VLOOKUP(F3,库存表!C:C,1,0)=O3,"ok","型号不对")) =IF(P8="OK",VLOOKUP(F8,库存表!C:F,3,0),"") 老师上述3个函数公式在表达什么，请老师翻译一下，谢谢！

914

=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是什么意思啊

1086

IF($A8="华美达","月结","现结",IF($A8="皇尊酒店","月结","现结",IF($A8="星湖KTV","月结","现结",IF($A8="维也纳音乐会所","月结","现结",IF($A8="金色港湾音乐会所","月结","现结",IF($A8="凯都会大酒店","月结","现结",IF($A8="新星湖KTV(金星湖）","月结","现结",IF($A8="*"&恒晟超市&"*","月结","现结")))))))) 显示公式错误，是错哪呢

842

最新问答

老师还有一个问题，长期股权投资--损益调整，什么情况下要转入到留存收益呢？ 17小时前

第8题这个甲公司所得税率15%，当期所得税费用为什么按25%计算啊？昨天

如下图，因为存货怎么影响应纳税所得额的昨天

财务工作描述中包括哪些方面的内容？ 1个月前

现金流量表的编制方法有哪些？主要有直接法和间接法两种。 1个月前

下载APP，拍照搜题秒出结果