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

设函数f(x)=2x-cosx,{An}是公差为(π/8)的等差数列,f(a1)+f(a2)+…f 　2020-04-05 …

已知MN⊥PQ于点O，点A1和点A关于MN对称，点A2和点A关于PQ对称，试证明：点A1和点A2关　2020-05-02 …

数学问这题的一个步骤是怎么来的因为f(a1)+f(a2)+f(a3)+f(a4)+f(a5)=5π 　2020-05-17 …

下列公式中一定成立的是(49)。A.πA1,A2(σF(E))≡σF(πA1,A2(E))B.σF( 　2020-05-26 …

假设关系R(A1,A2,A3)上的函数依赖集F={A1→A2,A1→A3,A2→A3},则函数依赖( 　2020-05-26 …

设f(x)=ax2bxc,满足f(a1)=0,f(a2)=0,f(a3)=1,(其中:a1,a2, 　2020-07-09 …

设f(x)=ax2+bx-c,满足f(a1)=0,f(a2)=0,f(a3)=1,(其中:a1,a 　2020-07-09 …

设f(N)、g(N)是定义在正数集上的正函数.如果存在正的常数C和自然数N0,使得当N≥N0时有f 　2020-07-31 …

如图．过点A1（1，0）作x轴的垂线，交直线y=2x于点B1；点A2与点O关于直线A1B1对称，过点　2020-10-31 …

算法复杂度计算中Max{f,g}=O（f+g）是否正确?如果正确的话错误的话请举例.注意,需要证明的　2021-01-14 …