EXCEL 提取N个括号内的字符答:B1=MID(A1,FIND("(",A1),FIND(")",A1)-FIND("(",A1)+1)&MID(A1,FIND("@",SUBSTITUTE(A1,"(","@",2)),FIND("@",SUBSTITUTE(A1,")","@",2))-FIND("@",SUBSTITUTE(A1,"(
excel表格使用if函数问题,显示您输入的公式错误,如果您输入的不是公式...答:Excel 如何实现函数IF的嵌套超过七层 A1=1,则B1=A;A1=2,则B1=B……A1=26,则B1=Z 解决方法如下:B1=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",C1)))C1=IF(A1=9,"I",IF(A1=10,"J...