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?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
2280038217525545912
true
Search Help Center
true
true
true
false
false