试用Excel函数实现检测数据的修约

Rounding Off Testing Data with Excel Function

应用Excel中的IF、AND、INT、EVEN、FIXED、ROUND函数编写命令,使Excel应用软件在数据处理时能按数据修约规则进行修约。通过应用证明,此命令完全满足数据修约规则的要求,对数据的处理准确、稳定,减轻了检测人员的工作压力,具有极强的可操作性和实用价值。

When the Excel functions （IF, AND, INT, EVEN, FIXED, ROUND） are used to write the com- mands, the Excel software could round off the data to the rules during the data processing. The applications show that this command can meet the requirements of rounding off data. The data could be processed in an accurate and stable way. The work load of the testing staff is relieved. It is highly practical.