View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carmanah_bc carmanah_bc is offline
external usenet poster
 
Posts: 1
Default how to calculate the difference between two bearings

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)

Anyone have any experience with math like this? (used to calculate direction
of a ROV based on instrument data)