is there a formula for this?

A visit to Chip Pearson's site is in order:
http://www.cpearson.com/excel/latlong.htm



Jon re Excel wrote:

is there a formula for this?

--

Dave Peterson

On Tue, 8 Mar 2005 16:33:03 -0800, Jon re Excel <Jon re
wrote:

is there a formula for this?


=60*180/PI()*ACOS((SIN(RADIANS(Pos1 Lat)) * SIN(RADIANS(Pos2 Lat)))
+ (COS(RADIANS(Pos1 Lat)) * COS(RADIANS(Pos2 Lat)) *
COS(RADIANS(Pos2 Long) - RADIANS(Pos1 Long))))

Pos1 Lat is the Latitude, in decimal degrees of position 1
and so forth.

Positions in the N latitudes and W longitudes are entered as postive numbers.
Positions in the S latitudes and E longitudes are entered as negative numbers.

The result will be in nautical miles.




--ron