麻烦更正一下IF函数

13834680194

=IF(-60<=A2>-70,"[-70 -60)",IF(-70<=A2>-80,"[-80 -70)",IF(-50<=A2>-60,"[-60 -50)",IF(-10<=A2>-50,"[-50 -10"))))
这个函数是错误的，但是不知道错误在什么地方，麻烦各位大侠更正，谢谢！

clarezhang

=IF(AND(A2>-80,A2<=-70),"[-80 -70]",IF(AND(A2>-70,A2<=-60),"[-70 -60]",IF(AND(A2>-60,A2<=-50),"[-60 -50]",IF(AND(A2>-50,A2<=-10),"[-50 -10]",""))))
OR =LOOKUP(A2,{-80,-79,-69,-59,-49,-9},{"","[-80 -70]","[-70 -60]","[-60 -50]","[-50 -10]",""})

13834680194

clarezhang 发表于 2012-3-20 23:35
=IF(AND(A2>-80,A2-70,A2-60,A2-50,A2

谢谢！！！！