Excel Calculating Distance between two points.

Hi All,

Trying to create an easy to use function in VBA from the complicated formula below.

but i cant seem to get it working? Any help be much appreciated!

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

Please Login or Register  to view this content.

Just to clarify... are you trying to work out distance between two Lat/Long points? If so, why not save some time and use something like the Google API - it is free and simple to implement to calculate distance.

Yeah thats correct. Using Longitude and Latitude.

The issue is the sheer volume of points i would need to analyse a formula actually works out easier for the type of analysis i require