求EXCELif函数高手(有关超过7个条件的),=IF(A1-查字典问答网
分类选择

来自靳宏磊的问题

  求EXCELif函数高手(有关超过7个条件的),=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H",""))))))))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A1=

  求EXCELif函数高手(有关超过7个条件的),

  =IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H",""))))))))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A1=12,"L",IF(A1=13,"M",IF(A1=14,"N",IF(A1=15,"O",IF(A1=16,"P",""))))))))&IF(A1=17,"Q",IF(A1=18,"R",IF(A1=19,"S",IF(A1=20,"T",IF(A1=21,"U",IF(A1=22,"V",IF(A1=23,"W",IF(A1=24,"X",""))))))))&IF(A1=25,"Y",IF(A1=26,"Z",""))

  这种类型的嵌套,为什么enter之后显示OFALSE

2回答
2020-09-26 23:54
我要回答
请先登录
孔维姝

  没必要这样

  给你一个公式吧

  =IF(AND(A1>=1,A1

2020-09-26 23:55:03
靳宏磊

  我的还不是这个,具体的您能帮我看看吗=IF($A$1=1,SUMIF(Sheet2!$M$5:$M$367,B16,Sheet2!$D$5:$D$367))以此类推共有10个

2020-09-26 23:55:55

最新问答

推荐文章

猜你喜欢

附近的人在看

推荐阅读

拓展阅读

  • 大家都在看
  • 小编推荐
  • 猜你喜欢
  •