![LATLNGDISTANCE]({"bg": "//theme.zdassets.com/theme_assets/9691885/e106cc8a79a6a41c781c71d999cffaa33b481de7.jpg"})
![LATLNGDISTANCE]({"bg": "//theme.zdassets.com/theme_assets/9691885/d38d9cc5a4fcb160800cb7a8f0e0cb60aaa36d2e.jpg"})
The function LATLNGDISTANCE returns the distance between two global positions in miles, kilometers, or nautical miles.
Declaration
LATLNGDISTANCE(latitude1, longitude1, latitude2, longitude2, unit_string) -> distance
Parameters
- 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 unites
Examples
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 miles is 4120.151831261931
LATLNGDISTANCE(40.7648, -73.9797, 37.431136, -122.14044, "k") -> 4120.151831261931
Though you'll never get there without practice.