excel取模mod和roundup公式应用

excel每隔6行加1,6行之间为空：

=IF(MOD(ROW(A1),6)=1,100+ROUNDUP(ROW(A10)/6,0),”“)

excel每隔6行加1,6行之间为上一个数：

=IF(MOD(ROW(A1),6)=1,101+ROUNDUP(ROW(A6)/6,0),100+ROUNDUP(ROW(A6)/6,0))
效果如下：

101101101101101101102102102102102102103103103103103103104104104104104104105