
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
geo coordinates add calculate
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great!
I will try as soon as we solve the NUM - Problem.
Wolfgang

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hallo,
vielleicht hilft Num(replace(Lat, '.', ','))?
VG
Henry


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If NUM is not working, I'm using ROUND().

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or try Round(num#(latitude),'0.0000001')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great Formula,
thank you.
Wolfgang

- « Previous Replies
-
- 1
- 2
- Next Replies »