Thread: [Solved] Adding station numbers
View Single Post
 
Old 01-27-2015, 07:46 AM
mbenton mbenton is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Jan 2015
Posts: 7
mbenton is on a distinguished road
Default

In my first post I asked how I could get excel to add station numbers together.
example: (1+50.23) + (2+36.46) = (3+86.69)

You showed me how I could convert a station number to a gereral number by using =LEFT(A1,FIND("+",A1)-1)*100+RIGHT(A1,LEN(A1)-FIND("+",A1))

I can use that to convert (1+50.23) to 150.23 and (2+36.46) to 236.46 so I can then add 150.23 and 236.46 and come up with the sum of 386.69 but now I must display 386.69 as the station number 3+86.69.

I need a formula like you gave me above to convert the general number 386.69 back to a station number 3+86.69.
Reply With Quote