A1:投票价B1:评标基准值C1:=(B1-A1)/B1(格式用百分比)D1:得分=if(C1<0,If(C1<-0.3,0,30+Int(C1*100)),If(C1<=0.1,30+Int(C1*100),If(C1>0.5,0,50-Int(C1*100))))