區間值平分得分 計總分 (14579)

C2=(SUM(N(OFFSET(G$1,LOOKUP(1,0/(B2>=F$2:F$10),ROW($1:$9))+{0;1},))*{-1;1})/SUM(N(OFFSET(F$1,LOOKUP(1,0/(B2>=F$2:F$10),ROW($1:$9))+{0;1},))*{-1;1}))*(B2-VLOOKUP(B2,F:FG,1))+VLOOKUP(B2,F:G,2)