EXCEL按比例记取 公式怎么编写啊？例如投标报价与评标基准价相比，等于评标基准价的得40分；每上浮5%扣0.5

Question

如题所述

Answer 1

评标基准价A1，投票报价B1，得分C1可以用公式：
=A1-FLOOR((B1-A1)/A1/0.05,1)*0.5

Answer 2

投标报价 评标基准价 上浮率 得分
50000 50000 =(A2-B2)/B2 =IF((A2-B2)/B2>=0.05,40-0.5*INT(C2/0.05),40)
55000 50000 =(A3-B3)/B3 =IF((A3-B3)/B3>=0.05,40-0.5*INT(C3/0.05),40)
50500 50000 =(A4-B4)/B4 =IF((A4-B4)/B4>=0.05,40-0.5*INT(C4/0.05),40)
52500 50000 =(A5-B5)/B5 =IF((A5-B5)/B5>=0.05,40-0.5*INT(C5/0.05),40)
52499 50000 =(A6-B6)/B6 =IF((A6-B6)/B6>=0.05,40-0.5*INT(C6/0.05),40)
52550 50000 =(A7-B7)/B7 =IF((A7-B7)/B7>=0.05,40-0.5*INT(C7/0.05),40)

Answer 3

=IF(A1>=$C$1,40-0.5*INT(((A1-$C$1)/$C$1)/0.05),40)

C1单元阁为评标基准价
A列为投标报价

Answer 4

这个简单，你要是分高的话发个表过来我可以帮你做。