作业帮这个公式啥意思?=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/04/28 14:26:06
![这个公式啥意思?=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),](/uploads/image/z/6751918-46-8.jpg?t=%E8%BF%99%E4%B8%AA%E5%85%AC%E5%BC%8F%E5%95%A5%E6%84%8F%E6%80%9D%3F%3DIF%28AND%28OR%28B43%3DROUNDDOWN%28B37-B38-B39-B40-B41-B42%2C2%29%2CB43%3DROUNDUP%28B37-B38-B39-B40-B41-B42%2C2%29%29%2CB43%3D%27%5B20110414094011097609194.xls%5D1%E8%B5%84%E4%BA%A7%E8%B4%9F%E5%80%BA%E8%A1%A8%27%21B64%29%2C%22%E6%AD%A3%E7%A1%AE%22%2C%22%E9%94%99%E8%AF%AF%22%29)
这个公式啥意思?=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),"错误")