| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to calculate the difference between two bearings
Thanks, the ABS function is a good solution.
"Stan Brown" wrote: 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/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate difference between two times | Excel Worksheet Functions | |||
| Calculate the difference between two times | Excel Worksheet Functions | |||
| Calculate the difference two times | Excel Discussion (Misc queries) | |||
| How do I calculate Time difference from PM to AM | Excel Discussion (Misc queries) | |||
| Calculate difference between two dates | Excel Worksheet Functions | |||
![carmanah_bc[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
