excel 满分100分,与基准值相比每增加1%扣2分,每减少1%扣1分,最多扣2...答:B2=IF(IF(ROUND((A2-$B$1)/$B$1*100,0)>0,ROUND((A2-$B$1)/$B$1*100,0)*2,IF(ROUND((A2-$B$1)/$B$1*100,0)<0,ROUND((A2-$B$1)/$B$1*100,0)*(-1),0))>20,20,IF(ROUND((A2-$B$1)/$B$1*100,0)>0,ROUND((A2-$B$1)/$B$1*100,0)*2,IF(ROUND(...