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

Rounding Off Testing Data with Excel Function

作　　者：寸松梅 杨一云 杨国先[1] 杨军慧[1] 

机构地区：[1]云南省烟草公司保山市公司,云南保山678000

出　　处：《环境科学导刊》2012年第4期120-124,共5页Environmental Science Survey

摘　　要：应用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.

关 键 词：检测数据 EXCEL函数 数据修约 

分 类 号：X84[环境科学与工程—环境工程]