第1个回答 2013-04-07
扣减分值的中间值用插入法?,这句话,不懂?
a在A1平均数b在B1,在C1输入(这个是用4舍5入,浮动1.4%,算1%,1.5%,算2%)
=IF(A1=B1,100,IF(A1>B1,MAX(100-0.4*round((A1-B1)/A1/0.01),0),MAX(100-0.2*round((B1-A1)/A1/0.01),0),"")
第2个回答 2013-04-07
=IF(B1=A1,100,IF(100*(B1-A1)/A1=INT(100*(B1-A1)/A1)+1,IF(B1>A1,100-100*(B1-A1)/A1*0.2,100-100*(B1-A1)/A1*0.4),IF(B1>A1,FIXED(100-100*(B1-A1)/A1*0.2,2),FIXED(100-100*(B1-A1)/A1*0.4,2))))