=IF(B2<0.3,0,IF(B2<=0.6,A2*B2/2,IF(B2<=1,A2*B2,A2)))
=if(b<0.3,0,if(b>0.6,if(b*a>1000,1000,b*a),b*a/2))
假设A2=1000,B2为完成率=IF(B2<0.3,0,IF(0.3<=B2<=0.6,A2*B2/2,IF(0.6望采纳!
if(b<0.3,0,if(b<0.6,a*b/2,a*b))