Trig Hell
Posted by Neil White on December 13, 2001 3:42 AM
I have constructed a spreadsheet to calculate distance and bearing between given points, the problem is that if the bearing is over 180 degrees it shows as a minus number, i need to show as a positive!!! any suggestions PLEASE!!!
Posted by Dank on December 13, 2001 6:07 AM
What's your formula? I think we'd need to see this to give a full solution to your problem.
Regards,
Dank.
Posted by Jacob on December 13, 2001 8:58 AM
Hi
Excel has a absolute value capability so just type
=abs(your formula)
This way the answer will always be positive
Jacob
