IF的三个条件怎么写呢答:底宽=IF(J5<1.2,IFS(D5=150,"600",D5=200,"800",D5=300,"900",D5=400,"1000"),IF(J5>3,IFS(D5=300,"1200",D5=400,"1400"),IFS(D5=200,"1100",D5=300,"1200",D5=400,"1400",D5=400,"1000"))管径D5 ,深埋J5,...
if函数,多个条件怎么使用答:函数公式如下:=if(A1>=50%,"畅销款",if(And(A1>=30%,A1<50%),"平销款",if(A1<30%,"滞销款")))具体解释如下:公式:=IF(条件1,返回结果1,IF(条件2,返回结果2,IF(条件3,返回结果3,...)))(原理 就是先判断条件1是否成立,如果条件1成立则返回结果1,否则进入条件2判断是否成立...