这个公式啥意思?=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/06 07:40:16
这个公式啥意思?=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),
x){yԥZ5̵tpsp21 sqp26u2bK]' 6b##M< ԣ L M ,M@,Ks3KCKX[[Zb ^,\dfl )(2J6IE8|*/Q&O'L|EG֥FOsip-]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),"错误")