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

1:如图,用与竖直方向成30度角的力F将重为10N的物体推靠在光滑的竖直墙上,求当物体沿着墙匀速滑　2020-04-27 …

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

已知函数f(x)=ax+b,当x属于[a1,b1]时,f(x)的值域为[a2,b2],当x属于[a 　2020-06-02 …

一个关于求导数的答案不明白的地方求f(x)=2x^2+x-1(x>0)的反函数在x=2处的切线的斜　2020-06-06 …

设函数f（x）在x=0处连续，下列命题错误的是（）A．若limx→0f(x)x存在，则f（0）=0 　2020-06-12 …

已知函数.其中.（1）若曲线y＝f(x)与y=g(x)在x＝1处的切线相互平行,求两平行直线间的距　2020-07-21 …

设a1,a2,a3,a4是齐次线性方程组Ax=0的一个基础解系,则下列向量组中不再是Ax=0的基础　2020-08-02 …

物理学中滑动摩擦力的大小计算公式为f=μN，式中μ叫动摩擦因素，N为正压力，现有一物体G受到向右水　2020-08-02 …

设向量a1=(a,10,2),a2=(-2,5,1),a3=(-1,4,1),B=(1,c,b),讨　2020-10-31 …