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

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

德布罗意波长公式求教注:v频率E=hνv=c／λ所以E=hc／λh／λ=E／cp=hν／cc=vλ 　2020-06-22 …

一个9位数abcdefghi满足：1.a+b+...+h+i=cd2.a(b+d-c)=243.( 　2020-07-19 …

已知函数f(x)=e^x+a/e^x(a为实数)问:(1)若函数y=|f(x)|在[0,1]上单调　2020-07-20 …

写单词,这些单词打乱顺序了!：1.d,f,e,n,i,f,e,r,t,()2.g,h,o,e,t, 　2020-07-26 …

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

一个9位数abcdefghi满足：1.a+b+...+h+i=cd2.a(b+d-c)=243.(e 　2020-11-19 …

是高数王子的请进a.limf(x)g(x)=limh(x)如果右边存在且limf(x)存在那么lim 　2020-12-10 …

英语：下1.将下联打乱的字母组成单词,并写出汉语意思1.a,e,h,g,c,n[]2.e,i,s,t 　2020-12-10 …

“我们可以得到A和B分别与C、D、E之间的关系”这句话用英语怎么表达“我们可以得到A和B分别与C、D 　2020-12-25 …