excel公式
9个回答
展开全部
C2用公式：
=LOOKUP(B2,{1,46,150,180,200,231,250,301},{"1组","","2组","","3组","","4组",""})
下拉。
=LOOKUP(B2,{1,46,150,180,200,231,250,301},{"1组","","2组","","3组","","4组",""})
下拉。
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
C2公式如下，下拉
=IF(AND(B2>=1,B2<=45),1,IF(AND(B2>=150,B2<=179),2,IF(AND(B2>=200,B2<=230),3,IF(AND(B2>=250,B2<=300),4,""))))
=IF(AND(B2>=1,B2<=45),1,IF(AND(B2>=150,B2<=179),2,IF(AND(B2>=200,B2<=230),3,IF(AND(B2>=250,B2<=300),4,""))))
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
可以在C2输入公式
=LOOKUP(B2,{1,50,150,180,200,231,250,301},{"1组","","2组","","3组","","4组",""})
下拉填充。
=LOOKUP(B2,{1,50,150,180,200,231,250,301},{"1组","","2组","","3组","","4组",""})
下拉填充。
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
C2=CHOOSE(MATCH(B2,{1,46,150,180,200,231,250,301},1),"1组","","2组","","3组","","4组","")
向下复制粘贴
向下复制粘贴
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
=IF(AND(B2>=1,B2<=45),"1组",IF(AND(B2>=150,B2<=179),"2组",IF(AND(B2>=200,B2<=230),"3组",IF(AND(B2>=250,B2<=300),"4组",""))))
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
更多回答（7）
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
