Question

excel中输入公式时出现“输入太多参数”的问题

http://zhidao.baidu.com/question/92637847.html
您好，"=IF(COUNTIF(跑步组!$J:$J,M5)>0,VLOOKUP(M5,跑步组!$J:$K,2,),"")&IF(COUNTIF(跑步组!$J:$J,M5)>1,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000,65536),2))),"")&IF(COUNTIF(跑步组!$J:$J,M5)>2,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000,65536),3))),"")&IF(COUNTIF(跑步组!$J:$J,M5)>3,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000,65536),4))),"")&IF(COUNTIF(跑步组!$J:$J,M5)>4,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000,65536),5))),"")
"这个公式输入时，显示“输入太多的参数”不知这是怎么回事？望指点，谢谢

Answer 1

ROW($1:$1000,65536),有这种用法吗？括号位置错啦：

=IF(COUNTIF(跑步组!$J:$J,M5)>0,VLOOKUP(M5,跑步组!$J:$K,2,),"")&IF(COUNTIF(跑步组!$J:$J,M5)>1,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000),65536),2)),"")&IF(COUNTIF(跑灶烂蠢步组!$J:$J,M5)>2,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000),65536),3)),"")&IF(COUNTIF(跑步组!$J:$J,M5)>隐陪历缺3,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000),65536),4)),"")&IF(COUNTIF(跑步组!$J:$J,M5)>4,","&INDEX(跑步组!$K:$K,SMALL(IF(跑步组!$J$1:$J$1004=M5,ROW($1:$1000),65536),5)),"")

Answer 2

公式有多处错误:
如:
跑步组!$J:$J,M5)>1,","&INDEX
逗号位置不对.应该为:
跑含乎步组!$J:$J,M5)>庆袭1,"",INDEX

如:
ROW($1:$1000,65536),
括号位誉老兄置不对,应该为:
ROW($1:$1000),65536),

Answer 3

if函数只能嵌套7层