将B改为B1 =IF(B1<-0.02,-30%,IF(B1<-0.01,-20%,IF(B1<0,-10%,IF(B1<=0.01,10%,IF(B10.02,30%,IF(B1>0.01,20%,IF(B1>=0,10%,IF(B1>-0.01,-10%,IF(B1>-0.02,-20%,-30%))))) 这两个的效果一样
=if(and(a1<=1500,a1>1),a1*3%,"")这样就好了不满足条件返回空！
