Distance Formula for Latitude and Longitude

**dankappa** · 11-21-2006, 08:03 AM

I need help with the formula for computing mileage between points using latitude and longitude. I have obtained this formula:

RadiusEarth*ACOS(COS(RADIANS(90-(Lat1*24)))*COS(RADIANS(90-(Lat2*24)))+
SIN(RADIANS(90-(Lat1*24)))*SIN(RADIANS(90-(Lat2*24)))*
COS(RADIANS(24*(Long1-Long2))))

I have the figure for the radius of the Earth, 3956 miles.

I want to caluculated the distance of several of addresses from one address.

Can anyone assist me?

Dan

**davesexcel** · 11-21-2006, 08:18 AM

http://www.cpearson.com/excel/latlong.htm
http://support.microsoft.com/default.aspx/kb/254676

**dankappa** · 11-21-2006, 08:29 AM

Thanks Dave!

**fazna ali** · 11-05-2012, 11:10 PM

Hi dankappa,
have u found the solution on latitude and longitude calculation.?
i've try and make some alteration of the coding from http://www.cpearson.com/excel/latlong.htm with the help from other excel forum user. The coding is as below :

Please Login or Register  to view this content.

However, when i try to run the macro, it turn to have
compile error:
Argument not optional

i think it because of the

Cells(i, 5) = GreatCircleDistance(Lat1, long1, Lat2, long2)

does not declare all argument from the GreatCicrcleDistance function. but when i put all the arguments to the equation, nothing is happen.

Actually how to apply the function so it can be use in the excel sheet.?

Thank you very much in advance.

**arlu1201** · 11-06-2012, 01:50 AM

Fazna,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.