EXCEL多个IF输入进去不识别？

Question

请大神帮忙看下，我这个公式哪里错了，为什么有的显示FALSE，有的又可以显示出来

Answer 1

excel公式书写格式错误！

修改，简化为：

=if(0.3>=L3,"小于30%",IF(and(L3>0.3,L3<0.6),"小于60%",IF(AND(L3>=60%,L3<90%),"小于90%","大于90%")))，

如有需要可以继续交流！

Answer 2

if(0.3<L3<=0.6
语法错误
要写为
IF(AND(L3>0.3,L3<=0.6),"小于60%",
后面的同理

Answer 3

公式格式不对
应改为：=IF(L3<=0.3,"小于30%",IF(AND(L3>0.3,L3<=0.6),"小于60%",IF(AND(L3>0.6,L3<=0.9),"小于90%","大于90%")))
或者：=IF(L3<=0.3,"小于30%",IF(L3<=0.6,"小于60%",IF(L3<=0.9,"小于90%","大于90%")))本回答被提问者采纳

Answer 4

公式修改为
=IF(L3>=0.9,"不小于90%",IF(L3>=0.6,"不小于60%",IF(L3>0.3,"大于30%","不大于30%")))
或
=IF(L3<=0.3,"不大于30%",IF(L3<0.6,"大于30%",IF(L3<0.9,"不小于60%","不小于90%")))

Answer 5

在M2单元格输入以下公式，然后向下填充公式
=IF(L2<0.3,"小于30%",IF(L2<0.6,"小于60%",IF(L2<0.9,"小于90%","大于等于90%")))