| 描述 | 公式 |
| 工程修约-取整 | =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位小数 | =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)) |
| 工程修约-取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)) |
| 工程修约-取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)) |
| 工程修约-取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)) |
| 工程修约-取2小数（WPS） | =ROUNDBANK(A2,2) |
| 指定范围随机整数 | =RANDBETWEEN(2580,2628) |
| 绝对值 | =ABS(c9) |
| 四舍五入取整 | =ROUND(c10,0) |
| 查找函数 | =VLOOKUP(e11,c11:d13,2,FALSE) |
| 方差 | =VARP(A1,A2) |
| 标准差 | =STDEVP(A1,A2) |
| 变异系数 | =STDEVP(A1,A2)/AVERAGE(A1,A2)*100 |
