计算總得分 依規定 (9861)

L6:L8{=SUM(IF(B6:J6<=B$4:J$4,100,IF(B6:J6>=B$5:J$5,,(B$5:J$5-B6:J6)/(B$5:J$5-B$4:J$4)/1%))*B$3:J$3)

B10:J12=IF(B6<=B$4,100,IF(B6>=B$5,0,((B$5-B6)/(B$5-B$4)*100)))

K10:K12{=SUM(B$3:J$3*(0&B10:J10))