在E2中输入或复制粘贴下列公式=IF(AND(C2/D$2>=0.9,C2/D$2<=1),50,"")或=(C2/D$2>=0.9)*(C2/D$2<=1)*50下拉填充
E2=IF(AND(C2/D$2>=0.99,C2/D$2<=1),50,0)
