EXCEL小数处理函数

名称具体演示结果说明=TRUNC(4.3)44.3的整数部分=TRUNC(-0.8)0-0.8的整数部分=ROUND(0.3115,0)00.3115四舍五入到整数=ROUND(0.3115,1)0.30.3115四舍五入到1位小数=ROUND(0.3115,2)0.310.3115四舍五入到2位小数=ROUND(0.3115,3)0.3120.3115四舍五入到3位小数=ROUNDDOWN(10.528,0)1010.528向下舍入到整数位=ROUNDDOWN(10.528,1)10.510.528向下舍入到1个小数位=ROUNDDOWN(10.528,2)10.5210.528向下舍入到2个小数位=ROUNDUP(10.528,0)1110.528向上舍入到整数位=ROUNDUP(10.528,1)10.610.528向上舍入到1个小数位=ROUNDUP(10.528,2)10.5310.528向上舍入到2个小数位=CEILING(2.5,1)3将2.5向上舍入到最接近的1的倍数=CEILING(-2.5,-2)-4将-2.5向上舍入到最接近的-2的倍数=CEILING(-2.5,2)返回值错误，因为-2.5和2的符号不同=CEILING(1.5,0.1)1.5将1.5向上舍入到最接近的0.1的倍数=CEILING(0.234,0.01)0.24将0.234向上舍入到最接近的0.01的倍数=INT(3.5)3将3.5向下舍入取整=INT(-3.5)-4将-3.5向下舍入取整ROUNDUPCEILINGINTTRUNCROUNDROUNDDOWN