doflamingo
doflamingo

Reputation: 77

The result by haversine formula is meter o kmeter?

I use the haversine formula to calculate the distance among the points. The result of this formula is in meter or in kmeter?

http://en.wikipedia.org/wiki/Haversine_formula

Anyone can help me?

Upvotes: 5

Views: 18233

Answers (1)

user2965004
user2965004

Reputation: 75

Haversine formula is used for finding distance between to points, if latitude and longitude for both points are known.

Formula:

ACOS(SIN(Lat1)*SIN(Lat2) +COS(Lat1)*COS(Lat2)*COS(Lon2-Lon1)) *6371

Excel formula:

=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371

Note:

Replace 6371 with 3958.756 if you want the answer in miles.

For further detail:

http://bluemm.blogspot.in/2007/01/excel-formula-to-calculate-distance.html

Upvotes: 3

Related Questions