Skip to content

检测常用excel公式

描述公式实例输入值实例输出值
工程修约-取整=IF(ROUND(ABS(ROUND(c2,0)-c2),5)=0.5,ROUND(c2,0)-(ROUND(ROUND(c2,0)/2,0)-ROUND(c2,0)/2)*2,ROUND(c2,0))1.563552
工程修约-取1位小数=IF(ROUND(ABS(ROUND(C3,1)-C3),5)=0.05,ROUND(C3,1)-(ROUND(ROUND(C3,1)/2,1)-ROUND(C3,1)/2)*2,ROUND(C3,1))1.563551.6
工程修约-取2小数=IF(ROUND(ABS(ROUND(C4,2)-C4),5)=0.005,ROUND(C4,2)-(ROUND(ROUND(C4,2)/2,2)-ROUND(C4,2)/2)*2,ROUND(C4,2))1.563551.56
工程修约-取3位小数=IF(ROUND(ABS(ROUND(C5,3)-C5),5)=0.0005,ROUND(C5,3)-(ROUND(ROUND(C5,3)/2,3)-ROUND(C5,3)/2)*2,ROUND(C5,3))1.563551.564
工程修约-取10=IF(ROUND(ABS(ROUND(C6,-1)-C6),5)=5,ROUND(C6,-1)-(ROUND(ROUND(C6,-1)/2,-1)-ROUND(C6,-1)/2)*2,ROUND(C6,-1))9923.659920
指定范围随机整数=RANDBETWEEN(2580,2628)----2611
指定范围随机小数=RANDBETWEEN(2580,2628)/10----262.3
绝对值=ABS(c9)-1212
四舍五入取整=ROUND(c10,0)59.4559
查找函数=VLOOKUP(e11,c11:d13,2,FALSE)e11选定值,c11、d13为范围值----
方差=VARP(A1,A2)--------
标准差=STDEVP(A1,A2)--------
变异系数=STDEVP(A1,A2)/AVERAGE(A1,A2)*100--------