is there a formula for this?
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
[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks