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

来源：百度知道 编辑：UC知道 时间：2024/07/02 17:30:25
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))),"")
"这个公式输入时，显示“输入太多的参数”不知这是怎么回事？望指点，谢谢

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

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

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)),"")

if函数只能嵌套7层