Forum Discussion
Distance between Latitude and Longitude in Excel
How can I derive the distance between two points in Excel given Latitude and Longitudes?
Hello,
Point A =>A2/B2 (ex : 45.762°/4.822°)
Point B =>C2/D2 (ex: 44.869°/-0.533°)
Result : 430 Km
| =2*6371*ASIN(RACINE((SIN((RADIANS(C2)-RADIANS(A2))/2))^2+COS(RADIANS(C2))*COS(RADIANS(A2))*(SIN((RADIANS(D2)-RADIANS(B2))/2))^2)) |
| =ACOS(SIN(RADIANS(A2))*SIN(RADIANS(C2))+COS(RADIANS(A2))*COS(RADIANS(C2))*COS(RADIANS(B2-D2)))*6371 |