excel的平均数肿么保留1位小数

excel

1个回答

写回答

937920663

2025-12-14 00:17

+ 关注

=OR(VALUE(RIGHT(INT(I52*1000),1))5,AND(VALUE(RIGHT(INT(I52*1000),1))=5,(I52*1000-INT(I52*1000))0),AND(VALUE(RIGHT(INT(I52*1000),1))=5,MOD(VALUE(RIGHT(INT(I52*100),1)),2)=1))*0.01+ROUNDDOWN(I52,1)

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号