excel取模mod和roundup公式应用

2019-04-13 17:05发布

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))
效果如下:
101 101 101 101 101 101 102 102 102 102 102 102 103 103 103 103 103 103 104 104 104 104 104 104 105