Question

excel中if多条件语句怎么编写

本人想把左侧那列数据的后面加入右侧数据的范围，用excel编写的语句如下，求大神赐教，怎么编写
=IF(6<=G4<8,I4=K4,IF(8<=G4<15,I4=K5,IF(15<=G4<35,I4=K6,IF(35<=G4<40,I4=K7,IF(G4=K8,I4=K8,IF(40<G4<50,I4=K9,IF(50<=G4<60,I4=K10,IF(60=G4,I4=K11,IF(60<G4<60,I4=K12)))))))))

Answer 1

 =IF(OR(A4<6,A4>=80),"数据溢出",VLOOKUP(IF(A4=40,6,IF(A4=60,9,VLOOKUP(A4+0.5,$C$4:$D$11,2,1))),$J$4:$K$13,2,))    

Answer 2

个人感觉用lookup函数会好点，看起来比较的清晰：

=LOOKUP(A1,{6,8,15,35,40,41,50,60,61,80},{"6≤t＜8","8≤t＜15","15≤t＜35","35≤t＜40","40","40＜t＜50","50≤t＜60","60","60＜t＜80","输入的数值不符合要求"})

附件是公式表格。

Answer 3

excel中没有这种写法：6<=G4<8
我们用and来表示并且关系，and(G4>=6,G4<8)

追问

=IF(AND(G4>=6,G4=6,G4=15,G4=35,G4<40),I4=K7,IF(AND(G4=40),

追答

=IF(AND(G4>=6,G4<8),K4,IF(G4<15,K5,IF(G4<35,K6,IF(G4<40,K7,IF(G4=40,K7,IF(G4<50,K8,IF(G4<60,K8,IF(G6=60,K9,IF(G6<80,K10,K11)))))))))
理论应该是这样，但是你的图没有贴出行列号，自己看着改吧
逻辑大概这样！

Answer 4

=IF(G4<80,IF(G4<50,IF(G4<35,IF(G4<15,IF(G4<6,"",70),60),45),25),20)
乙验证。