如何实现函数IF的嵌套超过七层?

Robbie_MO · 发表于 2009-8-4 11:08

看看我的简单方案：如果只有26个字母的话！
先看看附件就知道了：用char（）函数实现！够简单吗？

9a128 · 发表于 2009-11-20 22:09

[一个单元格也可以实现！
=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","“))]
谢谢半榻茶烟，受益！受益！！

nj_mason · 发表于 2010-2-1 11:19

太有用了。谢谢！

一和轩 · 发表于 2010-2-13 15:40

原帖由 Robbie_MO 于 2009-8-4 11:08 发表
看看我的简单方案：如果只有26个字母的话！
先看看附件就知道了：用char（）函数实现！够简单吗？

这个方法是简单，但上面的举例只是为了说明突破7层嵌套的思路。
学习了，谢谢论坛。

MAJING456 · 发表于 2010-2-28 16:21

=IF(C3="一四班",IF($B3=1,"15:30",IF($B3=2,"-",IF($B3=3,"15:30",IF($B3=4,"16:05",IF($B3=5,"14:50",""))))),IF(C3="一五班",IF($B3=1,"15:30",IF($B3=2,"-",IF($B3=3,"15:30",IF($B3=4,"16:05",IF($B3=5,"14:50",""))))),IF(C3="一三班",IF($B3=1,"15:30",IF($B3=2,"-",IF($B3=3,"15:30",IF($B3=4,"16:05",IF($B3=5,"14:50",""))))))))&IF(C3="一二班",IF($B3=1,"12:30",IF($B3=2,"-",IF($B3=3,"15:30",IF($B3=4,"16:05",IF($B3=5,"14:50",""))))))
结果出来是15:30FALSE或FALSE12：30

MAJING456 · 发表于 2010-3-5 10:51

IF(C3="一四班",IF($B3=1,"15:30",IF($B3=2,"-",IF($B3=3,"15:30",IF($B3=4,"16:10",IF($B3=5,"14:50",""))))),"")&IF(C3="一五班",IF($B3=1,"15:30",IF($B3=2,"-",IF($B3=3,"15:30",IF($B3=4,"16:10",IF($B3=5,"14:50",""))))),"")&IF(C3="一三班",IF($B3=1,"16:10",IF($B3=2,"15:30",IF($B3=3,"15:30",IF($B3=4,"-",IF($B3=5,"14:50",""))))),"")&IF(C3="一二班",IF($B3=1,"15:30",IF($B3=2,"16:10",IF($B3=3,"-",IF($B3=4,"15:30",IF($B3=5,"14:50",""))))),"")&IF(C3="一一班",IF($B3=1,"15:30",IF($B3=2,"-",IF($B3=3,"15:30",IF($B3=4,"16:10",IF($B3=5,"14:50",""))))),"")

[ 本帖最后由 MAJING456 于 2010-3-5 10:56 编辑 ]

xxh7836 · 发表于 2010-3-13 23:45

妙啊，学习了

zhuoruhang · 发表于 2010-6-9 11:30

解决了我的困扰，谢谢了

donghan · 发表于 2010-6-9 12:02

2007可以64层嵌套

wangsongjll · 发表于 2010-6-9 13:16

定义名称好像网站有

		自动登录	找回密码
密码			免费注册

如何实现函数IF的嵌套超过七层?

&不能实现超嵌套的问题

已解决