How to Calculate Azimuth in Excel
By Lindsey Mason
An azimuth is defined as "an arc of the horizon measured between a fixed point and the vertical circle passing through the center of an object." This measurement is often used in the fields of astronomy, navigation and artillery. In order to calculate the azimuth using Microsoft Excel, you will need the geographic coordinates of both points being used and the distance between them.
Entering the Geographic Coordinates
Select the destination cells for the latitude and longitude of both points and right-click.
Select "Format Cells" and click "Time."
Choose the "hh:mm:ss" format and click "OK."
Select new destination cells for converting the "Time" values to degrees.
Enter this formula: "=[destination cell]*24." This is necessary for correct calculation.
Entering the Formula
Select your destination cell.
Enter this formula: "=ASIN(COS(RADIANS([Latitude 2 cell])*SIN([Distance])/SIN(RADIANS([Longitude 2 cell]-[Longitude 1 cell])))))." The conversion to radians is necessary for the trigonometric functions to work properly.
Select a second destination cell and center this formula: "=DEGREES([Above destination cell])" to convert the answer from the formula back to degrees.
Lindsey Mason is a graduate of the University of Phoenix where she obtained an associate degree in information technology with a focus on programming. She works with many programming languages including Java, C++ and VBA. Mason has written many video-game and technical articles. She is an avid gamer and specializes in RPG video games.