ACCT(\"5602\",\"QSJFS\",\"\",0,0,0)老师，这个是什么意思？_Excel_财税问答-正保会计网校(原中华会计网校)_手机版

问题已解决

所属话题：

ACCT(\"5602\",\"QSJFS\",\"\",0,0,0)老师，这个是什么意思？

84785024 | 提问时间：2019 08/06 10:38

凡凡老师

金牌答疑老师

职称：中级会计师,经济师

你好，取数公式 =ACCT(5602,QSJFS,,0,0,0)解析： =ACCT(科目,取数类型,货币,年度 ,期始期间,结束期间,帐套配置名)取数函数。科目：科目就是会计科目。取数类型：（Y 期末余额）（JY 期末借方余额）（DY 期末贷方余额）（C 年初余额）（JC 年初借方余额）（DC年初贷方余额）货币：为空年度: 默认为0 期始期间,结束期间：0代表当期，1代表年初帐套配置名：默认为空

2019 08/06 13:16

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

相关问答

=ACCT("1901.01","Y","",0,0,0)+ACCT("2221","JY","",0,0,0,"")+ACCT("2221.02","JY","",0,0,0,"")中ACCT表示什么意思 JY表示什么意思 000表示什么意思

17

=ACCT("1122","JY","",0,0,0,"") 我的资产负债表，应收账款科目，6月份有一条减少应收账款的分录，资产负债表的应收账款栏目，未识别怎么办，=ACCT("1122","JY","",0,0,0,"")这个公式是什么意思

1678

=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

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

1052

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

841

最新问答

老师，请问一下这种情况，我们公司买的手机，客户积分够一定额度换手机，购入的手机如何做账？ 6小时前

100的成本，赚标价100%的利润，这个东西标价多少？昨天

请问老师，注会考试分录后面写了公式会不会扣分昨天

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

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

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