U6公式：
=IF((SUM(H6:L6)>=30)*(SUM(H6:L6)<50),(H6*0.25+I6*0.5+J6+K6+L6)*0.003,"")
在U6输入公式：
=if(and(sum(h6:l6)>=30,sum(h6:l6)<50),(H6*0.25+I6*0.5+J6+K6+L6)*0.003,"不符合")
U6=if((H6+I6+J6+K6+L6)=30,(H6*0.25+I6*0.5+J6+K6+L6)*0.003,H6+I6+J6+K6+L6)
=IF(AND(SUM(H6:L6)>=300000,SUM(H6:L6)<500000), SUMPRODUCT(H6:L6,{0.25,0.5,1,1,1})*0.003,"")
=IF(AND(SUM(H6:L6)>=30,SUM(H6:L6)<50),(H6*0.25+I6*0.5+J6+K6+L6)*0.003,"")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024