convert an angle to a bearing in excel

I can’t believe I had difficulty with this one for so long:

 =MOD(450-angle,360)
This assumes you’re measuring the angle in the usual Cartesian way; anticlockwise from the x-axis.

Send the author to the moon!

One thought on “convert an angle to a bearing in excel”

  1. It appears that the same formula can be use to convert from a bearing back to an angle: =MOD(450-bearing,360). But I could be wrong.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>