|
发表于 2018-6-11 10:23:28
|
显示全部楼层
利润表公式:
第1页!D5 = FS(\"5101\", 0, \"贷方\")
第1页!D6 = FS(\"5401\", 0, \"借方\")\n第1页!D7 = D5-D6-D7\n第1页!D9 = FS(\"5102\", 0, \"贷方\")-FS(\"5405\", 0, \"借方\")\n第1页!D10 = FS(\"5501\", 0, \"借方\")\n第1页!D11 = FS(\"5502\", 0, \"借方\")\n第1页!D12 = FS(\"5503\", 0, \"借方\")\n第1页!D13 = D8+D9-D10-D11-D12\n第1页!D14 = FS(\"5201\", 0, \"贷方\")\n第1页!D15 = FS(\"5203\", 0, \"贷方\")\n第1页!D16 = FS(\"5301\", 0, \"贷方\")\n第1页!D17 = FS(\"5601\", 0, \"借方\")\n第1页!D18 = D13+D14+D15+D16-D17\n第1页!D19 = FS(\"5701\", 0, \"借方\")\n第1页!D20 = D18-D19\n第1页!E5 = LFS(\"5101\", 0, \"贷方\")\n第1页!E6 = LFS(\"5401\", 0, \"借方\")\n第1页!E7 = LFS(\"5402\", 0, \"借方\")\n第1页!E8 = E5-E6-E7\n第1页!E9 = LFS(\"5102\", 0, \"贷方\")-LFS(\"5405\", 0, \"借方\")\n第1页!E10 = LFS(\"5501\", 0, \"借方\")\n第1页!E11 = LFS(\"5502\", 0, \"借方\")\n第1页!E12 = LFS(\"5503\", 0, \"借方\")\n第1页!E13 = E8+E9-E10-E11-E12\n第1页!E14 = LFS(\"5201\", 0, \"贷方\")\n第1页!E15 = LFS(\"5203\", 0, \"贷方\")\n第1页!E16 = LFS(\"5301\", 0, \"贷方\")\n第1页!E17 = LFS(\"5601\", 0, \"借方\")\n第1页!E18 = E13+E14+E15+E16-E17\n第1页!E19 = LFS(\"5701\", 0, \"借方\")\n第1页!E20 = E18-E19
|
|