I am trying to make an excel spreadsheet that a person can input 2 8 figure grids and it will give the range and bearing from one to the other and then will calculate the elevation based of range and altitude difference.
The two grids are: 2309 1746 and 2270 1750 in cells C2, D2 and C2, C3 respectively.
I have the range working using this formula: =(SQRT((Power(C2-C3,2) + Power(D2-D3,2))))*10
The bearing formula I found is: =ABS(DEGREES(ATAN2(COS((C2))*SIN((C3))-SIN((C2))*COS((C3))*COS((D3-D2)),SIN((D3-D2))*COS((C3)))))*17.78
But it does not give me the correct bearing which is 5147 mils. Anyone any ideas?