改成保留1位小数和两为小数的 要求原理不变=IF(A1>(CEILING(A1,0.001)+FLOOR(A1,0.001))/2,CEILING(A1,0.001),IF(A1

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/07 04:20:18
改成保留1位小数和两为小数的 要求原理不变=IF(A1>(CEILING(A1,0.001)+FLOOR(A1,0.001))/2,CEILING(A1,0.001),IF(A1

改成保留1位小数和两为小数的 要求原理不变=IF(A1>(CEILING(A1,0.001)+FLOOR(A1,0.001))/2,CEILING(A1,0.001),IF(A1
改成保留1位小数和两为小数的 要求原理不变
=IF(A1>(CEILING(A1,0.001)+FLOOR(A1,0.001))/2,CEILING(A1,0.001),IF(A1

改成保留1位小数和两为小数的 要求原理不变=IF(A1>(CEILING(A1,0.001)+FLOOR(A1,0.001))/2,CEILING(A1,0.001),IF(A1
改为1位小数:
1、查找0.001替换为0.1
2、查找TRUNC(A1,3)替换为TRUNC(A1,1)
同理
改为2位小数
1、查找0.001替换为0.01
2、查找TRUNC(A1,3)替换为TRUNC(A1,2)