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,"有点冷","暖和")))可以采纳啦。……。。……。……。。……...
excel的if函数问题,如何同时满足5个条件答:=IF(F4="初中",5,IF(OR(F4={"中专","中技","高中"}),10,IF(F4="大专",15,IF(OR(F4={"大本","本科"}),20,25)))
if函数如果有5个条件答:if(a>3%,a,if(0<a<=3%,b,if(a=0,c,if(-5%<=a<0,d,if(a<-5%,e,"在大于3%和小于-5%这个上边应该还有个条件"))))