Thanks for reporting.
The distance function returns always in meters. The map, depending on your locale, will return measurements in miles or km.
From my own testing, the measurements are correct. Attaching an XLSForm so you can see how to do the unit conversions.