DISTANCE()

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()