第1个回答 2013-01-31
在B2输入
=IF(AND(A2>=0,A2<100),"LV1",IF(AND(A2>=100,A2<200),"LV2",IF(AND(A2>=200,A2<300),"LV3")))
回车,下拉
追问好用了,谢谢,我自己写了一个,说我输入太多参数。我一共有10级,这两组数字要放第二列和第三列(B和C),你帮我一起写出来呗,谢谢。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b292df5e0fe9925554cf36635a85edf8db17140?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第2个回答 2013-01-31
A1填写数字150
B1公式(返回“LV2”结果)
=IF(OR(A1="",A1>300),"",LOOKUP(A1,{0,100,200},{"Lv1","Lv2","Lv3"}))
第3个回答 2013-01-31
="Lv"&CEILING((1+A1)/100,1)
第4个回答 2013-01-31
=IF(AND(A1>0,A1<100),"Lv1",IF(AND(A1>=100,A1<200),"Lv2","Lv3"))
第5个回答 2013-01-31
=IF(AND(A1>=200,A1<300),"Lv3",IF(AND(A1>=100,A1<200),"Lv2",IF(AND(A1>0,A1<100),"Lv1")))