摘要:
⑴功能把数值沿绝对值减小的方向进行舍入为指定数值的倍数。⑵格式FLOOR(数值或数值单元格,指定的数)⑶示例A列 B列1245.251……= FLOOR(A1,5)=1245= FLOOR(A1,4)=1244= FLOOR(A1,3)=1245= FLOOR(A1,2)=1244= FLOOR(A1,1)=1245第2个参数不能是0,换句话说,没有一个确定的数是0最接近的倍数。= FLOOR(A1,0.1)=1245.2(= FLOOR(A1,0.2)=1245.2= FLOOR(A1,0.3)=1245= FLOOR(A1,0.4)=1245.2= FLOOR(A1,0.7)=1244.6 阅读全文