I am trying to calculate angle changes from GPS coordinates. I have three points and am using the law of cosines to find the angle. I calculate the distance between the GPS points using the distance formula:
The points of interest are (B3,D3) (B4,D4) and (B5,D5). There are two examples in the attachment, the first where the formula works and it returns a number, and the second where it returns the #NUM! error. When I click "Show Calculation steps," it says that ACOS(-1) is going to result in a calculation error.Please Login or Register to view this content.
I have tried calculating the number inside ACOS(_) into another cell. The result is -1. I have tried taking the ACOS(_) of this new cell but it results in a #NUM! error. I have also tried taking the ACOS(_) of a cell into which I paste special the value, and it results in a #NUM! error as well.
Inputting =ACOS(-1) in a cell results in a numerical answer and no error
My questions are this:
Is the formula I am using incorrect and therefore creating some numberical errors? How can I fix this?
My goal is to calculate angle changes for hundreds of points as a car goes along a route.
Bookmarks