if怎么在数据中设置《一级》《二级》《三级》《四级》《五级》...《十二级》这几个条件啊?IF函数不能同时输入这么多条件啊?怎么办
excel中IF函数的怎么设置多个条件?
答案:3 悬赏:60
解决时间 2021-02-18 00:48
- 提问者网友:星空下的寂寞
- 2021-02-17 21:33
最佳答案
- 二级知识专家网友:一池湖水
- 2021-02-17 23:09
如果你是要将成绩1到12分别对应十二级到一级的话,用下面的方法。
设成绩列为a列。在b2输入:
=VLOOKUP(A2,{1,"十二级";2,"十一级";3,"十级";4,"九级";5,"八级";6,"七级";7,"六级";8,"五级";9,"四级";10,"三级";11,"二级";12,"一级"},2,0)
然后下拉就可以了。
设成绩列为a列。在b2输入:
=VLOOKUP(A2,{1,"十二级";2,"十一级";3,"十级";4,"九级";5,"八级";6,"七级";7,"六级";8,"五级";9,"四级";10,"三级";11,"二级";12,"一级"},2,0)
然后下拉就可以了。
全部回答
- 1楼网友:青春如此荒謬
- 2021-02-18 01:08
=if(a1>7,"优",if(a1>5,"良",if(a1>4,"中",if(a1>3,"差","极差")))) ------------------------------------------ 或者 =if(or(a1={2,3}),"极差",if(a1=4,"差",if(a1=5,"中",if(or(a1={6,7}),"良",if(a1=8,"优",""))))) ------------------------------------------ 可以用lookup函数做 =lookup(a1,{2,4,5,6,8},{"极差","差","中","良","优"})
- 2楼网友:荒唐后生
- 2021-02-17 23:40
=IF(A2="一级",12,IF(A2="二级",11,IF(A2="三级",10,IF(A2="四级",9,IF(A2="五级",8,IF(A2="六级",7,IF(A2="七级",6,IF(A2="八级",5,IF(A2="九级",4,IF(A2="十级",3,IF(A2="十一级",2,IF(A2="十二级",1,))))))))))))
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯