检测常用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.56355 | 2 |
| 工程修约-取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.56355 | 1.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.56355 | 1.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.56355 | 1.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.65 | 9920 |
| 指定范围随机整数 | =RANDBETWEEN(2580,2628) | ---- | 2611 |
| 指定范围随机小数 | =RANDBETWEEN(2580,2628)/10 | ---- | 262.3 |
| 绝对值 | =ABS(c9) | -12 | 12 |
| 四舍五入取整 | =ROUND(c10,0) | 59.45 | 59 |
| 查找函数 | =VLOOKUP(e11,c11:d13,2,FALSE) | e11选定值，c11、d13为范围值 | ---- |
| 方差 | =VARP(A1,A2) | ---- | ---- |
| 标准差 | =STDEVP(A1,A2) | ---- | ---- |
| 变异系数 | =STDEVP(A1,A2)/AVERAGE(A1,A2)*100 | ---- | ---- |