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

[附加减加班]+ 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) <---大概意思如此

感谢各位指点

多谢斑竹~我去试试~~