excel如何修约到0.5（excel相差0.01怎么调整）

=IF(FLOOR(A1-FLOOR(A1,0.5),0.25)>0,CEILING(A1,0.5),FLOOR(A1,0.5))有点罗嗦，不知道有没有更简单的 补充：进行两次修约=CEILING(FLOOR(A1,0.25),0.5)