Thread: how to auto-convert angle in the range from 0 to 360

Hi, just want to ask a question in excel.

Now I have a set of data, which are the angles from -720 to 720. I am wondering whether EXCEL can auto-convert these angles back to be in the range from 0 to 360 degree.

For example, if the original angle is -90, it will be converted to 270.

Sincerely,

With the angle in A1, type this formula in B1: =MOD(360+A1,360). If you wish. create a series from -720 to 720 in steps of x (your choice), and copy this formula down next to the range.

hth
Mike