On Mon, 11 Aug 2003 20:19:33 GMT, Jimmy wrote:

Hi guys/gals,

I am trying to figure out how to add and subtract two degrees. I am
speaking about compass/directional degrees (or angles if you prefer).

I need to be able to subtract lets say 45 degrees from a heading/angle
of 020 and arrive at the appropriate result. In this case 335.


Also how can I display the result or format the field to display a
leading "zero" ie 020.

Thanks in advance

I think this will work as a worksheet formula:

=MOD(Heading+Change,360)

To subtract, enter Change as a negative number.

=mod(20 + (-45),360) -- 335

Format/Cells/Number/Custom Type: 000
or, if you want to be fancy, 000\°

To insert the degree sign, hold down the <alt key while typing -- on the
NUMERIC KEYPAD -- 0176.


--ron