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

 

[Tetra201]

Try

=MOD(O80,180)

 

[Bobby1980]

Hey,

Gave that a go but it came came up with a "False" statement, is there anything else at all that anyone could possibly suggest?

 

[Tetra201]

What exactly do you have in cell O80?

 

[Bobby1980]

What exactly do you have in cell O80?

=(INT(U76))

It was to separate the bearing from the minutes and seconds, anything you could possibly suggest.

 

[jtakw]

Hi,

I think the formula in Tetra's Post #2 is meant as a "stand alone" formula for what you were asking, I "think" you might have inserted it within Your IF formula (otherwise, can't see how you can get a FALSE return).

I'm not entirely sure if this will produce Exactly the results you want (the description and your formula in OP doesn't exactly match up):

Book1
	O	P	Q
80	-50		130
81	0		0
82	100		100
83	180		180
84	181		1
85	200		20
86	359		179
87	360		180
Sheet69

Cell Formulas
Range	Formula
Q80	=SUM(O80,IFERROR(LOOKUP(O80,{0,181},{0,-180}),180))

 

[Bobby1980]

Thankyou kindly will give it ago again

 

[Bobby1980]

It works with just a value ie
1
2
2
3
3
etc
but if I say the value of that cell is =a1 for example the =MOD(o80-180) doesn't work and returns a false value.

Can you possibly suugest anything that may overcome this at all?

 

[jtakw]

It works with just a value ie
1
2
2
3
3
etc
but if I say the value of that cell is =a1 for example the =MOD(o80-180) doesn't work and returns a false value.

Can you possibly suugest anything that may overcome this at all?

Unless that's a typo in red, Tetra's formula is =MOD(O80,180) with a "comma", Not a "minus".

Also, did you try my formula in Post #6 ??

 

[Bobby1980]

Unless that's a typo in red, Tetra's formula is =MOD(O80,180) with a "comma", Not a "minus".

Also, did you try my formula in Post #6 ??

Thank you so much, you guys are so clever it worked thankyou