求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函数高手(有...的网友还看了以下：

在等差数列{an}中,Sn为其前几项和,(1)a1=14.5,d=0.7,an=25,求Sn.(2 　2020-05-14 …

--RIGHT是什么意思?试了试以下三种情况：=IF(OR(--RIGHT(A1+1,1)=4,- 　2020-05-16 …

小学数学问题计算（能简算的要简算）要过程4920*24-17x124/7*（13/14+15/16 　2020-05-17 …

方程√7(1+x)/(√7+√2)+√2/(√7-√2)=0的根是x=（）.A.（√14-7）/9 　2020-06-03 …

某化工厂采用新技术后，每天用原料14吨.这样，原来7天用的原料，现在可以用10天.这个厂现在比过去　2020-06-04 …

请高手指教公式＝IF（OR（A1＝1,A1＝3,A1＝5,A1＝7,A1＝9）,“奇”,“偶”）. 　2020-06-07 …

已知等比数列{an}中an>0,a1+a2+...+a8=4,a1*a2*...*a8=16,则1 　2020-06-08 …

口算：3.14×2=3.14×3=3.14×4=3.14×5=3.14×6=3.14×7=3.14 　2020-07-18 …

7辆同样的卡车3天可以运黄沙120吨，增加了同样的14辆3天可以运黄沙多少吨？下面的算式中，正确的　2020-07-21 …

求EXCELif函数高手(有关超过7个条件的）,=IF(A1=1,"A",IF(A1=2,"B", 　2020-07-23 …