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

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/26 04:56:31
改成保留1位小数和两为小数的 要求原理不变=IF(A1>(CEILING(A1,0.001)+FLOOR(A1,0.001))/2,CEILING(A1,0.001),IF(A1
x){6e糎 O}>uᓽO7?餞';<ٱ }>EŲg>Ɏާ3l=4 4]=}<܁l=CMm7 _SHCXMR>%n맊C lMpB~,g>lg* !A~ 5b`O'dBd~qAb(>

改成保留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)