论谈下载的手工做账模板,我改动了下,科目余额表中试算不平衡了

xinjingtaiji

我对以下单元格的公式进行了修改,改后H93,H95,变成试算不平衡了,请指出我的公式到底错在哪里了啊,并改正,谢谢啊 科目余额表H93=IF(AND(SUMIF($G$6:$G$90,"借",D6:D90)-SUMIF($G$6:$G$90,"贷",D6:D90)>=-0.0001,SUMIF($G$6:$G$90,"借",D6:D90)-SUMIF($G$6:$G$90,"贷",D6:D90)<=0.0001),"试算平衡","试算不平衡，借贷差异"&SUMIF($G$6:$G$90,"借",D6:D90)-SUMIF($G$6:$G$90,"贷",D6:D90)&"元")

科目余额表H94'=IF(AND(E91-F91>=-0.0001,E91-F91<=0.0001),"试算平衡","试算不平衡，借贷差异"&E91-F91&"元")

科目余额表H95'=IF(AND(SUMIF($G$6:$G$90,"借",H6:H90)-SUMIF($G$6:$G$90,"贷",H6:H90)>=-0.0001,SUMIF($G$6:$G$90,"借",H6:H90)-SUMIF($G$6:$G$90,"贷",H6:H90)<=0.0001),"试算平衡","试算不平衡，借贷差异"&SUMIF($G$6:$G$90,"借",H6:H90)-SUMIF($G$6:$G$90,"贷",H6:H90)

xinjingtaiji

科目汇总表借贷方分开试算平衡表