·在EXCEL中,怎样实现当X=A,B,C时,Y=1,当X=D,E,F,G,时,Y=2， .当X=H,I,J时，Y=3
2个回答
展开全部
假定自变量为A1单元格,因变量为B1单元格,则在B1单元格输入公式:
[=LOOKUP(A1,{"A","B","C","D","E","F","G","H","I","J";1,1,1,2,2,2,2,3,3,3})]
[=LOOKUP(A1,{"A","B","C","D","E","F","G","H","I","J";1,1,1,2,2,2,2,3,3,3})]
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
