求助eval - 用户社区 - 易表在线答疑 - 简单实用的数据管理软件|数据统计软件|数据分析软件|电子表格软件

SumFor("

1班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"") + SumFor("

2班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"") + SumFor("

3班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"") + SumFor("

5班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"") + SumFor("

6班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"") + SumFor("

7班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"")

eval("SumFor(""+substitute("1|2|3|5|6|7","|","班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"") + SumFor("")+"班组考勤情况","工时数","姓名", "=" ,[姓名],"月份", "=" ,[%月份%],"姓名", ">" ,"")")

上面那段函数用eval翻着这样哪里错了。原函数没有错的。

Eval("SumFor(""" + substitute("1|2|3|5|6|7","|","班组考勤情况"",""工时数"",""姓名"", ""="" ,[姓名],""月份"", ""="" ,[%月份%],""姓名"", "">"" ,"""") + SumFor(""") + "班组考勤情况"",""工时数"",""姓名"", ""="" ,[姓名],""月份"", ""="" ,[%月份%],""姓名"", "">"" ,"""")")

引号中的引号需要使用双引号，如 " SumFor( "" "

SumFor(""

1班组考勤情况"",""工时数"",""姓名"", ""="" ,[姓名]," "月份"", ""="" ,[%月份%],""姓名"", "">" ,"""") + SumFor(""

7班组考勤情况"",""工时数"",""姓名"", ""="" ,[姓名],""月份"", ""="" ,[%月份%],""姓名"", "">"" ,"""")

为了防止在代入公式时对引号的引用出错，建议先把公式的头、中、尾三部分在WORD文档中添加引号，再粘贴到正式公式相应的部分。如上面的粗体字符部分。

主题：求助eval