D2单元格写入公式=IF(AND(B2>=1,C2>=1),A2,IF(AND(B2>=0.8,C2>=0.8),0.6*A2,"没说明计算条件"))下拉填充公式
=IF(AND(B1>100%,C1>100%),"100%",IF(AND(B1>80%,C1>80%),"60%",""))
