I have been racking my brain triple checking my equation, and it's not
computing correctly.

I have:

=($M$1*ACOS(COS(I1)*COS(K5)))+(SIN(I1)*SIN(K5)*COS (J1-L5))

M1 is the earth radius

All in radians
I1: lat1
K5: lat2
J1: long1
L5: long2

For this example,
city 1: 0.74933823, 1.56014357
city 2: 0.750862496, 1.560638039

And it gives me 3985 as the answer. It should be 14.2.

Help please!!

Thanks





"Dave Peterson" wrote:

Take a look at Chip Pearson's notes:
http://cpearson.com/excel/latlong.htm



morchard wrote:

Is there a formula for deriving the great circle distance between two
points on the earth's surface when you have their latitude and
longitude?

The format I have the latitude/longitude in is:
Latitude Longitude
017/025S 145/030W
026/045S 141/000E
031/008N 033/048E
036/050N 008/000E

--
morchard
------------------------------------------------------------------------
morchard's Profile: http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=489407

--

Dave Peterson