I am working on bearings, so the numbers I am working with are within 360 degress.
In column Q of my worksheet I have a bearing between two sets of Eastings and Northings.
In column P I am looking to get the opposite number, if looking at a protractor for example. For the higher numbers simply taking 180 off works, but for the lower numbers the number in Column P becomes a negative.
So for example, in column Q i have 160 degrees, but in P it is showing as -20, but I want it to be 340 degrees.
Any ideas how to do this?