=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"))