I use the following formula to find the distance between two grid points on map.

D2 would contain a grid input in this format

35R LV 66008500

F2 would contain another grid input in the same format

35R LV 67008600

=TRUNC(SQRT(((((VALUE(MID(D2,8,4)))-(VALUE(MID(F2,8,4))))*10)^2)+ ((((VALUE(MID(D2,12,4)))-(VALUE(MID(F2,12,4))))*10)^2)))

This returns the hypotenuse of a right triangle essentially. The distances are correct, it value returned should be 1,414 (meters).

Then I use the following formula to calculate the angle between the two points (based off the right angle triangle created by the measurements calculated above):

=DEGREES(TANH((((VALUE(MID(A3,12,4)))-(VALUE(MID(C3,12,4)))))/(((VALUE(MID(A3,8,4)))-(VALUE(MID(C3,8,4)))))))

THE PROBLEM:

The answer returned is 43.6 degrees. Mathematically (or logically in my head) the answer should be 45 degrees.

-If the base (adjacent) of the triangle is 1000 and the side (opposite) is 1000, then the tan (radian converted to degrees) should be 45.

What am I doing wrong, or what am I miscontruing as the truth?

## Bookmarks