DISTANCE()

Distance between locations

Returns the direct, straight-line distance between the two given locations, in kilometers (km) as a Decimal value. Multiply the result by 0.621371 to get the distance in miles.

Sample usage

DISTANCE([Warehouse Location], [Customer Location]) returns the distance in kilometers (km) between the two locations.

(DISTANCE([Warehouse Location], [Customer Location]) * 0.621371) returns the distance in miles between the two locations.

DISTANCE([Destination Location], HERE()) returns the distance the destination and the current location, in km. See also: HERE()

Syntax

DISTANCE(location1, location2)

  • location1 - First location as a LatLong value.

  • location2 - Second location as a LatLong value.

See also

Capturing GPS Location

HERE()

LAT()

LATLONG()

LONG()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false