关于excel IF满足5个条件答:J2=IF(I2<3800,1,IF(AND(I2<=6000,I2>=3800),2,IF(AND(I2<=10000,I2>=6001),3,IF(AND(I2<=20000,I2>=10001),4,IF(I2>20000,5)))参考图片
EXCEL 表格中如何让IF函数满足5个条件答:=IF(A2<-10,"极冷",IF(A2<-5,"很冷",IF(A2<5,"冷",IF(A2<15,"有点冷","暖和")))在你自己的表中,把公式改为 =IF(E3<-10,"极冷",IF(E3<-5,"很冷",IF(E3<5,"冷",IF(E3<15,"有点冷","暖和")))可以采纳啦。……。。……。……。。……...
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判断是否成立...
excel IF 多个条件公式该怎么写?答:度友,公式这么写,要点就是同时满足多条件的书写,用and函数就好,具体公式为:=IF(A2<9000,B2*0.1+C2*0.04-1000,IF(AND(A2>=9000,A2<15000),B2*0.1+C2*0.04-500,IF(A2>=15000,B2*0.1+IF(C2<3000,C2*0.04,IF(AND(C2>=30000,C2<50000),C2*0.05,IF(AND(C2>=50000,C2<...