主题：[求助]刷新公式

我想用IF与Countfor函数写刷新公式.像下面这样写，结果提示表达式不正确.

If([考号] <= CountFor(Grid,"班级", "<=" ,"1"),第一考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"2"),第二考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"3"),第三考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"4"),第四考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"5"),第五考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"6"),第六考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"7"),第七考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"8"),第八考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"9"),第九考室,If([考号] <= CountFor(Grid,"班级", "<=" ,"10"),第十考室,第十一考室))))))))))

意思就是如果考号小于等于班级为1的数量时，考室为第一考室；如果考号大于班级为1的数量而小于等于班级为1与2的数量和时，考室为第二考室...........

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:89.egd

Eval("EvalFor(Grid,""考室"","""+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute(ListFor(Grid,"班级",1),"|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@",""",1,CountFor(Grid,""班级"",""="","),"|","))

什么意思？能解释一下吗？

谢谢了完全满足我的要求。