3 Replies Latest reply on Apr 13, 2018 5:24 AM by Bruce Henry

    Degree Bearing Calculated from a Pair on Lat Longs

    Walker Colt

      I have the lat long of one location and the lat long of another. My goal is to calculate the bearing of the line that would connect these two points in degrees. I have tried variations of this equation but cannot get it to work. Here is the current equation I am working with below.

       

      =ATAN2(COS(lat1)*SIN(lat2)-SIN(lat1)*COS(lat2)*COS(lon2-lon1),SIN(lon2-lon1)*COS(lat2))

       

      I have attached a workbook with what I have so far. Does anybody know how to help me?

       

      Thanks a lot.