![]() The second formula I found here and could be retrieved by downloading the spreadsheet. I believe this formula solves for nautical miles which is longer than the traditional mile. The first formula I found was from here and had the following sequence =3443.8985*(ACOS(SIN(N2)*SIN(R2)+COS(N2)*COS(R2)*COS(S2-O2))). From there I found two formulas (with help from the great and powerful ) to convert those coordinates into miles. NOTE: Ensure your cells are formatted to the correct data type to prevent error messages and incorrect outputs.Īfter successfully converting the coordinates into radians. Or by using the formula =(Value)/180)*PI(). Apply the =RADIANS() function to your latitudinal and longitudinal values. To convert latitudinal and longitudinal coordinates into miles first you must convert those coordinates into radians for excel. Here are the formulas/function and a breezy breakdown for it all. For those who are racking their brains (like I did) not knowing how to convert coordinates to radians.
0 Comments
Leave a Reply. |