Thread: how to calculate the difference between two bearings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default how to calculate the difference between two bearings
Mon, 7 May 2007 14:28:01 -0700 from carmanah_bc
:
I have a calculated direction field, which I want to compare to an actual
bearing, and display the results
e.g., calculated 180 degrees, actual -90 degrees: difference is 270 degrees
(absolute) or -90 (relative)

If calculated is in A1 and actual is in A2, then
=abs(A1-A2)
gives the absolute difference.

Are you sure that the relative is -90 degrees? I would have thought
that actual = -90 = 270, so the difference is 270-180 = +90.

Can you post the rules for computing the relative?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply With QuoteReply With Quote