用公式：=IF(AND(A1>=0.26,A1<=0.31),正常值,IF(A1<0.26,IF(A1<0.21,0,(正常值+正常值*(100*A1-26)*0.1)),IF(A1>0.36,0,(正常值-正常值*(100*A1-31)*0.1))))
