EXCEL IF 函数,数值B大于0,A等于10%,大于1%,A等于20%,小于0,A等于-10...答:将B改为B1 =IF(B1<-0.02,-30%,IF(B1<-0.01,-20%,IF(B1<0,-10%,IF(B1<=0.01,10%,IF(B1<0.02,20%,30%)))效果是一样的,公式要有逻辑性,=IF(B1>0.02,30%,IF(B1>0.01,20%,IF(B1>=0,10%,IF(B1>-0.01,-10%,IF(B1>-0.02,-20%,-30%)))这两个的效果一...