度友,看看这个公式:
具体公式为:=IF(A2<80,0,IF(A2>=80,80*0.4+(A2-80)*(0.4+(10/(A2-80)))))+IF(B2<=50,0,(B2-50)*(100/(100-50)))*0.5