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

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

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


DISTANCE( location1 , location2 )


  • location1 (a LatLong value)

  • location2 (a LatLong value)

Return Value

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

See Also

Capturing GPS Location, HERE(). LAT(), LATLONG(), LONG()

Did this answer your question?