=IF(AND(F4<24000,J4<2800000),"Com",IF(OR(F4>=24000,F4<29000,J4>=2800000,J4<3500000),"Ale",IF(OR(F4>=29000,J4>=3500000),"Act")))
F4小于24且J4小于28,显示com。24<=F4<29,或者28<=J4,35显示ale。到这里正常,最后F4>29或J4>35,显示Act。无效。错在哪里了?或者怎么写才正确?
谢谢大侠,诚心求助!
可以用函数向导来分析,会显示每一步的结果
分析结果:中间部分,你可以or()、and()套用,且必须套用。
=IF(AND(F4<24000,J4<2800000),"Com",IF(OR(AND(F4>=24000,F4<29000),AND(J4>=2800000,J4<3500000)),"Ale",IF(OR(F4>=29000,J4>=3500000),"Act")))