geo coordinates add calculate

[Anonymous]

Hi Folks,

for a distance calculation between geopoints I Need to add two latitutes

i.e.

51.0015983 + 52.6193168

I tried num and num#, but until now nothing works:-(

Please assist, for which I thank you all in advance

Wolfgang

[#2]

Hello. I know how to find the distance between two points of latitude and longitude with and

ceil(acos(sin(Lati1)*sin(Lati2)+cos(Lati1)*cos(Lati2)*cos(longi2-longi1))/pi()*180*1.852*60))

Perhaps this formula will help.

[marcus_sommer]

In addition to SergeyKostin if your values won't be recognized as numbers you might need to convert/format them like:

num(num#(YourValue, 'Formatcode'), 'Formatcode')

- Marcus

[Anonymous]

Danke, Marcus,

aber es will mir nicht gelingen. Formel

=num(num#(Y_Lat, '#.#'), '#,#')

gibt mir keine Nummer zurück. Auch habe ich die Formatcodes aus der Hilfe strapaziert, leider ohne Erfolg.

Danke,

Wolfgang

[Anonymous]

Great!

I will try as soon as we solve the NUM - Problem.

Wolfgang

[henrybrinkmann]

Hallo,

vielleicht hilft Num(replace(Lat, '.', ','))?

VG

Henry

[marcus_sommer · Accepted solution]

Wenn man Komma-Trenner und Tausender-Zeichen ändern möchte, muss man alle Parameter von num#() setzen, probier mal: num(num#(51.0015983, '#.#', '.', ','))

Schöne Grüße

Marcus

[#8]

If NUM is not working, I'm using ROUND().

[#9]

Or try Round(num#(latitude),'0.0000001')

[Anonymous]

Great Formula,

thank you.

Wolfgang