Question

Excel中的这种页码怎么编公式可以自动出？

如图，工作需要给一些资料编页码，每次都是手输很费劲，工作量也蛮大的。有没有什么公式能做到我输了页数后，能自动填写页码的？？谢谢！

Answer 1

D2输入：

=IF(C2=1,TEXT(SUM(C$1:C2),"0000"),TEXT(SUM(C$1:C1)+1,"0000")&"-"&TEXT(SUM(C$2:C2),"0000"))，下拉填充。

或者用：

=TEXT(SUM(C$1:C1)+1,"0000")&IF(C2=1,"","-"&TEXT(SUM(C$2:C2),"0000"))

Answer 2

=IF(C2>1,TEXT(1+SUM($C$1:$C1),"0000")&"-"&TEXT(SUM($C$2:$C2),"0000"),TEXT(SUM($C$2:$C2),"0000"))

应该是这样的