Excel bearing calculations

I want to find the compass bearing of to coordinates from a map: Map with example The middle Point is my location.

I already know the distance between my points. But I don't find a formula for the bearing that fits in an Excel sheet

``````=DEGREES(ATAN2(x2-x1,y2-y1))
``````

You can then use functions from here: https://www.mrexcel.com/board/threads/convert-number-in-deg-to-direction-text-n-nne.541185/ to allocate a map direction, this one appears best:

``````=CHOOSE(1+ROUND(A1/22.5,0),"N","NNE","NE","ENE","E","ESE","SE","SSE","S","SSW","SW","WSW","W","WNW","NW","NNW","N")
``````

or you can combine the lot in one cell something like:

``````=ROUND(DEGREES(ATAN2(B2,B3)),2) & "° " & LOOKUP(MOD(DEGREES(ATAN2(B2,B3)),360),{0,22.5,45,67.5,90,112.5,135,157.5,180,202.5,225,247.5,270,292.5,315,337.5},{"N","NNE","NE","ENE","E","ESE","SE","SSE","S","SSW","SW","WSW","W","WNW","NW","NNW"})
``````

where I have the X and Y calculations in B2 and B3.

It has been some time since I worked with coordinates so it may not be the correct terminology but you should be able to modify to suit.

• Thank you it worked. Apr 24, 2020 at 8:50