Chandra Bergmann Chandra Bergmann

The function LATLNGDISTANCE returns the distance between two global positions in miles, kilometers, or nautical miles.


LATLNGDISTANCE(latitude1, longitude1, latitude2, longitude2, unit_string) -> distance


latitude1 (type: number)
The latitude of the first position.
longitude1 (type: number)
The longitude of the first position.
latitude2 (type: number)
The latitude of the second position.
longitude2 (type: number)
The longitude of the second position.
unit_string (type: string, default: "m" - miles)
The unit of measurement the result should represent. Valid units are:
  • "k" - kilometers
  • "m" - miles
  • "n" - nautical miles

Return Values

distance (type: number)
The distance between the two positions in the units specified by the unit_string.


The distance between the latitude/longitude position (40.7648, -73.9797) and (37.431136, -122.14044) is 2560.1436555900605 miles.

LATLNGDISTANCE(40.7648, -73.9797, 37.431136, -122.14044) -> 2560.1436555900605

The same distance in kilometers is 4120.151831261931

LATLNGDISTANCE(40.7648, -73.9797, 37.431136, -122.14044, "k") -> 4120.151831261931


Was this article helpful?

0 out of 0 found this helpful

Articles in this section