求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"

题目详情

求EXCEL if函数高手(有关超过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

▼优质解答

答案和解析

没必要这样
给你一个公式吧
=IF(AND(A1>=1,A1

看了求EXCELif函数高手(有...的网友还看了以下：

=IF(OR(A1={1,3,5,7,9,10,12,14,16,18}),"合单","合双")这　2020-06-07 …

高手帮忙看看我这个公式=IF(OR(A1="A",A1="B"),1,IF(OR(A1="C"," 　2020-06-07 …

已知a1=t1+t，a2=11-a1，a3=11-a2，…，an+1=11-an（n为正整数，且t 　2020-07-09 …

有这样一组数据a1，a2，a3，…an，满足以下规律：a1＝12，a2＝11−a1，a3＝11−a 　2020-07-09 …

（2014•南充）一列数a1，a2，a3，…an，其中a1=-1，a2=11−a1，a3=11−a 　2020-07-09 …

if(a1=a2=a3=a4,1,0)与if(and(a1=a2,a3=a4,a4=a1),1,0 　2020-07-09 …

excel中在if函数中想用乘法怎么用比如，如果a1为1，则a2=b1*b2，否则为零，应该怎么写　2020-07-09 …

EXCEL公式疑问～=IF(ISERROR(IF(C7="A5大场",5000,SUM(OFFSET 　2020-10-31 …

EXCEL中,以下数组公式如何多增加一列进去?{=IF(AND(ISERROR(MATCH(1,(C 　2020-11-01 …

excel中如果计算结果不在范围内则其他单元格重新自动随机生成假定A1随机生成=50+INT(13* 　2020-11-24 …