rounddown

来源：学生作业帮助网 编辑：作业帮 时间：2024/08/30 13:39:21
这个公式啥意思?=IF(AND(OR(B43=ROUNDDOWN(B37-B38-B39-B40-B41-B42,2),

假如B43=向下舍入2位(B37-B38-B39-B40-B41-B42,2),或B43=向上舍入2位(B37-B38-B39-B40-B41-B42,2)),B43显示'[2011041409401

excel中round函数与rounddown函数区别?

ound四舍五入roundup全入rounddown全舍round(3.125,2)=3.13roundup(3.121,2)=3.13rounddown(3.129,2)=3.12

IF(OR(C12=ROUNDUP(C6-C11,2),C12=ROUNDDOWN(C6-C11,2)),"正确","错

ROUNDUP(C6-C11,2),是将C6数值减去C11数值,结果向上舍入为2位小数（即不管第3位小数是什么值,只要不是0,就向上收.）ROUNDDOWN(C6-C11,2),是将C6数值减去C11