在Excel表格中,根据考核实际值计算质量工资,目标值0.01%,实际为0.0065...答:如图片所示:F2=IF(D2<=0.00006,E2*1.25,IF(D2<=0.00007,E2*1.2,IF(D2<=0.00008,E2*1.15,IF(D2<=0.000099,E2*1.05,IF(D2<=0.0001,E2*1,IF(D2<=0.0002,E2*0.9,IF(D2<=0.0003,E2*0.8,IF(D2<=0.0004,E2*0.65,IF(D2<=0.0005,E2*0.4,0)))之后把公式...