Excel2003版IF函数限制7层,何不用LOOKUP函数=LOOKUP(Q2,{0,30,50,80,100,150,200,260,300,400;0,0.7,0.8,0.9,1,1.5,2,2.5,3,4})