这个公式啥意思?=IF(AND(OR(B43=ROUNDDOWN(B37-B38-B39-B40-B41-B42,2),B43=ROUNDUP(B37-B38-B39-B40-B41-B42,2)),B43='[20110414094011097609194.xls]1资产负债表'!B64),"正确","错误")
来源:学生作业帮助网 编辑:作业帮 时间:2024/11/29 02:31:45
x){yԥZ5̵tpsp21
sqp26u2 bK]' 6b##M < ԣ
LM,M@,Ks3KCKX[[Zb
^,\dfl)(2J6IE8| */Q&O'L|EG֥FOsip-]Di;ٌ}ϗ~B·z²34g " 1 ::;
这个公式啥意思?=IF(AND(OR(B43=ROUNDDOWN(B37-B38-B39-B40-B41-B42,2),B43=ROUNDUP(B37-B38-B39-B40-B41-B42,2)),B43='[20110414094011097609194.xls]1资产负债表'!B64),"正确","错误")
这个公式啥意思?
=IF(AND(OR(B43=ROUNDDOWN(B37-B38-B39-B40-B41-B42,2),B43=ROUNDUP(B37-B38-B39-B40-B41-B42,2)),B43='[20110414094011097609194.xls]1资产负债表'!B64),"正确","错误")
这个公式啥意思?=IF(AND(OR(B43=ROUNDDOWN(B37-B38-B39-B40-B41-B42,2),B43=ROUNDUP(B37-B38-B39-B40-B41-B42,2)),B43='[20110414094011097609194.xls]1资产负债表'!B64),"正确","错误")
假如 B43=向下舍入2位(B37-B38-B39-B40-B41-B42,2),或B43=向上舍入2位(B37-B38-B39-B40-B41-B42,2)),B43显示'[20110414094011097609194.xls1资产负债表'!B64),"正确",
否则,B43显示'[20110414094011097609194.xls]1资产负债表'!B64),"错误")