Excel Latitude and Longitude Calculations. Getting Started Accuracy is Important Excel Formulas for Distance Creating Excel Code for Distance Working With Angles in Excel Converting to Radians The Final Solution Problems Encountered The Longitude Latitude Code Excel Distance Calculation Workbook Excel Function Tutorials Thanks to Excel MVP, Jerry Latham, who contributed this tutorial for calculating distance.
Getting Started For those who are in a rush for the solution and don't need all the background information, jump to the longitude latitude code. The search for an accurate solution to this problem has led me to numerous sites and attempted solutions. A long list of related sites is included at the end of all of this, but the most crucial to what I've found to be the current end of the road are these: along with Accuracy is Important A formula that is accepted to provide results that are accurate to within millimeters is known as Vincenty's formula. =distVincenty(SignIt(B2), SignIt(C2), SignIt(B3), SignIt(C3)) GPS Visualizer. GPS Coordinate Converter, Maps and Info - Minefield. UTM & Lat/Lon Conversions.