Fornula for bearings greater than 180 but less than 359 and integrated with a formula less than 180 but greater than 0.

[Bobby1980]

Hi sorry am new to this,
I am trying to get a formula that can work out the reverse bearings 180 degree difference.
Tried
=if(and(o80>=180,o80<=359,o80-180)),if(and(o80<180,o80>0,o80+180))
Any help would be greatly appreciated

 

[alansidman]

try this

=IF(AND(O80>=180,O80<=359),O80-180,IF(AND(O80<180,O80>0),O80+180,""))

 

[Bobby1980]

Thank you Alan will give this a try

try this

=IF(AND(O80>=180,O80<=359),O80-180,IF(AND(O80<180,O80>0),O80+180,""))

 

[Tetra201]

Or this:

=MOD(O80-180,360)