这个公式啥意思?=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/15 19:43:21
这个公式啥意思?=IF(AND(OR(B43=ROUNDDOWN(B37-B38-B39-B40-B41-B42,2),B43=ROUNDUP(B37-B38-B39-B40-B41-B42,2)),

这个公式啥意思?=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),"错误")