www.jbmf.net > EXCEL 表格中如何让IF函数满足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,"有点冷","暖和")))) 可以采纳啦.……..…….……..……

用and() 比如同时满足a1>1和a1<6=if(and(a1>1,a1<6),"满足","不满足")

你的问题存在逻辑上的错误,看看我的if函数能否使用:=IF(A1>=50000,A1*0.04,IF(A1>=35000,A1*0.03,IF(A1>=25000,A1*0.02,IF(A1>=15000,A1*0.01,0))))

以下公式能满足要求,已试过 =IF(E3<60,"不及格",IF(E3<70,"及格",IF(E3<80,"中",IF(E3<90,"良","优"))))

使用多层嵌套的if函数就可以了

=IF(A2>5,IF(A2<10,"10",IF(A2<15,"15",IF(A2<20,"20","25"))),"5")

=IF((A1+B1)

=if(条件一,if(条件2,if(条件3,if(条件4,都满足的话怎样,不满足的话怎样))))

如果数据在A1开始的A列,那么输入 =TRIMMEAN(A:A,LOOKUP(COUNT(A:A),{0,5,7,9,11,13},{0,0.4,0.6,0.7,0.8,0.76})) 详见附图示例

=IF(AND(AC4>=6,AC4<=9.99),D4*0.08),IF(AND(AC4>=10,AC4<=13.99),D4*0.1),IF(AND(AC4>=14,AC4<=20),D4*0.16) 试试看 Excel不支持9.99>=AC4>=6

网站地图

All rights reserved Powered by www.jbmf.net

copyright ©right 2010-2021。
www.jbmf.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com