假设评标基准价在A1单元格,投标报价在B1单元格,得分在C1单元格,C1的公式如下:IF(AND(B1>=A1*(1-8%),B1<=A1*(1+5%)),44+2*(A1-B1)/A1/0.01,0)