投標價在B2,評標價在A2,得分為:. =CHOOSE(LOOKUP((B2-$A$2)/$A$2,{-1,-0.15,0,0.1},{1,2,3,1}),0,MIN(60,50-(B2-$A$2)/$A$2*100) ...
確定! 回上一頁