I’m trying to calculate bearing degrees for a couple of coordinates using this formula:
=DEGREES(ATAN2(COS(RADIANS(latA))*SIN(RADIANS(latB))-SIN(RADIANS(latA))*COS(RADIANS(latB))*COS(RADIANS(lonB-lonA)),SIN(RADIANS(lonB-lonA))*COS(RADIANS(latB))))
Set 1
LatA LongA LatB LongB
39.099912 -94.581213 38.627089 -90.200203
Set 2
LatA LongA LatB LongB
41.294253 -73.678856 41.293961 -73.678888
The bearing degrees calculator for set one is 96.51262423 which is correct.
Set 2 calculations is -175.2930015 which is incorrect.
Why is my excel set 2 calculation not correct? The expected calculation should be about 185.
