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.

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