主题：[求助]如何将这段代码改为循环

[附加减加班]+ if([1日] = 11.5,11.5,0)+if([2日] = 11.5,11.5,0)+if([3日] = 11.5,11.5,0)+if([4日] = 11.5,11.5,0)+if([5日] = 11.5,11.5,0)+if([6日] = 11.5,11.5,0)+if([7日] = 11.5,11.5,0)+if([8日] = 11.5,11.5,0)+if([9日] = 11.5,11.5,0) +if([10日] = 11.5,11.5,0)+ if([11日] = 11.5,11.5,0)+if([12日] = 11.5,11.5,0)+if([13日] = 11.5,11.5,0)+if([14日] = 11.5,11.5,0)+if([15日] = 11.5,11.5,0)+if([16日] = 11.5,11.5,0)+if([17日] = 11.5,11.5,0)+if([18日] = 11.5,11.5,0)+if([19日] = 11.5,11.5,0) +if([20日] = 11.5,11.5,0) + if([21日] = 11.5,11.5,0)+if([22日] = 11.5,11.5,0)+if([23日] = 11.5,11.5,0)+if([24日] = 11.5,11.5,0)+if([25日] = 11.5,11.5,0)+if([26日] = 11.5,11.5,0)+if([27日] = 11.5,11.5,0)+if([28日] = 11.5,11.5,0)+if([29日] = 11.5,11.5,0)+if([30日] = 11.5,11.5,0)+if([31日] = 11.5,11.5,0)

从1号加到31号
如何改为循环?

并且改运算为 if([N日] > 8,M=[N日]-8,0) <---大概意思如此

感谢各位指点

发文件上来

从1号加到31号，如何循环？是简化表达式吧？

[附加减加班]+Eval("If(["+Substitute("1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31","|","日] = 11.5,11.5,0)+If([")+"日] = 11.5,11.5,0)")

多谢斑竹~我去试试~~