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.

1 comment

  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 comment

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