Excel桩号递进公式

Question

我想第一个单元格是K87+943~K87+944.5,第二个单元格是K87+944.5~K87+946，一直这样1.5米加上去，公式怎么弄

Answer 1

=CONCATENATE("K87+",941.5+1.5*ROW(A1),"~K87+",943+1.5*ROW(A1))

追问

不是这样的，比如我到K87+999，再加1.5米就是K88+000.5，要这样的效果

追答

=TEXT(87941.5+1.5*ROW(A1),"K00+000.0"&"~"&TEXT(87943+1.5*ROW(A1),"K00+000.0"))

追问

可以了，最后还有一个问题请教你，比如我第一个还是K87+943~K87+945,加2米，第二个是K87+945~K87+948，加了3米，第三还是加2米，第四个加3米，一直这样2米、3米加下去，怎么实现

追答

=CONCATENATE(TEXT(ISODD(ROW())*2.5*(ROW()-1)+ISEVEN(ROW())*(2.5*ROW()-3)+87943,"K00+000"),"~",TEXT(ISODD(ROW())*2.5*(ROW()-1)+ISEVEN(ROW())*(2.5*ROW()-3)+87943+ISODD(ROW())*2+ISEVEN(ROW())*3,"K00+000"))

Answer 2

=TEXT(87941.5+ROW(1:1)*1.5,"K0+000"&IF(MOD(ROW(1:1),2),"",".0"))&TEXT(87941.5+ROW(2:2)*1.5,"~K0+000"&IF(MOD(ROW(2:2),2),"",".0"))

Answer 3

="K87+"&943+ROW(A1)*1.5-1.5&"~K87+"&943+ROW(A1)*1.5下拉