How to Use Excel to Calculate the Bearing Between Two Points

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Calculating the angle between two points on the globe is taking a bearing.

Calculating the bearing between two points on a map is an essential navigation skill for piloting and land orienteering. In the age of sail, ship's officers who stood a watch were expected to calculate these sorts of equations with look-up tables, rules of thumb and significant amounts of repetition. The modern era has made calculating bearings between two coordinates convenient with Excel.

Advertisement

Step 1

Start Excel, and enter the following text into the following cells:

Video of the Day

LatA in cell A1 LonA in cell C1 LatB in cell A2 LonB in cell C2

Step 2

Click on cell B1, then enter "LatA" in the drop-down to the left of the formula bar. Click on cell D1 and enter "LonA" in the drop-down as well.

Advertisement

Step 3

Click on cell B2, then enter "LatB" in the drop-down to the left of the formula bar. Click on cell D2 and enter "LonB" in the drop-down. You have named four variables, which will be used in an Excel formula.

Step 4

Click on cell A3 and enter the word "Bearing."

Advertisement

Advertisement

Step 5

Click on cell B3 and enter the following formula:

=MOD(ATAN2(SIN(LonB-LonA)_COS(LatB),COS(LatA_SIN(LatB)-SIN(LatA)*COS(LonB-LonA))),6.30318)

This formula will return the bearing you need to take to go from the coordinates on the first row to the coordinates on the second row. It will present the bearing as an angle that runs from 000 degrees (true north) to 359 degrees. The last term of the formula, "6.30318", is two times pi.

Video of the Day

Advertisement

Advertisement

references & resources