if函数超过7个,求指教!

2025-03-26 01:39:33
推荐回答(1个)
回答1:

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})