MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


Posted by Jacob on December 13, 2001 8:58 AM


Excel has a absolute value capability so just type

=abs(your formula)

This way the answer will always be positive