t+ 应交税费重分类
其他流动资产:
qc :
QC("2221","","年")-QC("222101","","年")-IFF(QC("222101","年")<0,QC("222101","","年"),0)
qm:
QM("2221","","年","月")-QM("222101","","年","月")-IFF(QM("222101","","年","月")<0,QM("222101","","年","月"),0)
(ps:如有其他待处理处理流动资产损溢不可删除公式)
—
应交税费:
qc :
QC("2221","","年")-QC("222101","","年")+IFF(QC("222101","年")>0,QC("222101","","年"),0)
qm:
QM("2221","","年","月")-QM("222101","","年","月")+IFF(QM("222101","","年","月")>0,QM("222101","","年","月"),0)
—
(ps:上面不涉及转让金融商品应交增值税和代扣代交增值税,如果涉及用iff公式取值代入)