Correcting values > 180 but < 359, by finding the reverse bearings but leaving values that are <180 but >0 the same.

[Bobby1980]

Hi all,

I was wondering if someone was able to correct what I a trying to do and help me please.

I would like to keep the values >0 but <180 the same, but values >180 and <359 I would like it to find the reverse bearing.


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


This is what I was trying,


Kind Regards,

Rob

 

[jtakw]

You're welcome, welcome to the forum.