excel函数if嵌套次数太多,可不可以帮我精简一下?
来源:学生作业帮 编辑:神马作文网作业帮 分类:综合作业 时间:2024/09/30 10:32:07
excel函数if嵌套次数太多,可不可以帮我精简一下?
=IF(AND(D6="A",E6="初级"),220,IF(AND(D6="A",E6="中级"),280,IF(AND(D6="A",E6="高级"),340,IF(AND(D6="A",E6="技师"),460,IF(AND(D6="A",E6="高级技师"),500,IF(AND(D6="B",E6="初级"),140,IF(AND(D6="B",E6="中级"),200,IF(AND(D6="B",E6="高级"),260,IF(AND(D6="B",E6="技师"),380,IF(AND(D6="B",E6="高级技师"),420,IF(AND(D6="C",E6="初级"),110,IF(AND(D6="C",E6="中级"),160,IF(AND(D6="C",E6="高级"),220,IF(AND(D6="C",E6="技师"),340,IF(AND(D6="C",E6="高级技师"),380,"错误")))))))))))))))
是2003版本
=IF(AND(D6="A",E6="初级"),220,IF(AND(D6="A",E6="中级"),280,IF(AND(D6="A",E6="高级"),340,IF(AND(D6="A",E6="技师"),460,IF(AND(D6="A",E6="高级技师"),500,IF(AND(D6="B",E6="初级"),140,IF(AND(D6="B",E6="中级"),200,IF(AND(D6="B",E6="高级"),260,IF(AND(D6="B",E6="技师"),380,IF(AND(D6="B",E6="高级技师"),420,IF(AND(D6="C",E6="初级"),110,IF(AND(D6="C",E6="中级"),160,IF(AND(D6="C",E6="高级"),220,IF(AND(D6="C",E6="技师"),340,IF(AND(D6="C",E6="高级技师"),380,"错误")))))))))))))))
是2003版本
我也来写个公式:
=IF(AND(D6{"A","B","C"}),"错误",INDEX(CHOOSE(CODE(D6)-64,{220,280,340,460,500},{140,200,260,380,420},{110,160,220,340,380}),MATCH(E6,{"初级","中级","高级","技师","高级技师"},)))
=IF(AND(D6{"A","B","C"}),"错误",INDEX(CHOOSE(CODE(D6)-64,{220,280,340,460,500},{140,200,260,380,420},{110,160,220,340,380}),MATCH(E6,{"初级","中级","高级","技师","高级技师"},)))
excel函数if嵌套次数太多,可不可以帮我精简一下?
Excel函数IF嵌套问题,公式怎么写?这个太多了,我已经昏了.
EXCEL IF函数嵌套方法
excel里if嵌套4层怎么提示我您已为此函数输入太多个参数?
if函数嵌套 ,求各位高手帮我计算>=2000这个,用if函数嵌套公式,我自己做了一下,但是有错误,
excel if函数嵌套问题.见鬼了,
Excel中IF函数多层嵌套问题
Excel函数IF嵌套,求公式.
excel中if/or/and函数嵌套
Excel函数IF的嵌套:公式怎么写?
excel函数if公式怎么嵌套超过7层啊
excel 如何and、 if 、sumproduct函数嵌套使用