=IF(AND(I3>=3201,I3<=10000),"80",IF(AND(I3>=1201,I3<=3200),"50",IF(AND(I3>=10001,I3<=35000),"125",IF(AND(I3>=501,I3<=1200),"32",IF(AND(I3>=281,I3<=500),"20",IF(AND(I3>=151,I3<=280),"13",IF(AND(I3>=91,I3<=150),"8")))))))之前是这样的,我想把AQL2.5(级别1)的都搞进去,求大神指点下,谢谢!
åºé´ æ°å¼
2-8 2
9-15 2
16-25 3
26-50 5
51-90 5
91-150 8
151-280 13
281-500 20
501-1200 32
1201-3200 50
3201-10000 80
10001-35000 125
35001-150000 200