比如A1单元格中是X值,B1单元格是实际值在C1单元格输入=IF(B1=A1,4,IF(B1>A1,4+0.2*ROUND((B1-A1)/A1*100,0),4-0.5*ROUND((A1-B1)/A1*100,0)))
