Value(in degrees) +/- 90° (With restrictions)

[gfdwer2]

Hello guys need help for a formula. Any help would be appreciated.

Example:
X + 90° = Y
if Y exceed 360°, then subtract 360° from it.

X - 90° = Z
if Z results to a negative number then add 360° to it

NOTE:
Y - Z = 180 (Absolute Value)

Result should be:
Cell A1 = Y or Z (depends which has the smaller value)
Cell B1 = Y or Z (depends which has the bigger value)

 

[JamesCanale]

MrExcelPlayground24.xlsx
	M	N	O
5	290	90	20
6	45	-90	315
Sheet6

Cell Formulas
Range	Formula
O5:O6	O5	=MOD(M5+N5,360)

 

[saboh12617]

Hello,

You are looking for the MOD function.

Y = MOD(X + 90, 360)

Y = MOD(X - 90, 360)

So

A1 =MIN(MOD(X + 90, 360), MOD(X - 90, 360))

B1 =MIN(MOD(X + 90, 360), MOD(X - 90, 360))

 

[gfdwer2]

MrExcelPlayground24.xlsx
	M	N	O
5	290	90	20
6	45	-90	315
Sheet6

Cell Formulas
Range	Formula
O5:O6	O5	=MOD(M5+N5,360)

Thanks a lot

 

[gfdwer2]

Hello,

You are looking for the MOD function.

Y = MOD(X + 90, 360)

Y = MOD(X - 90, 360)

So

A1 =MIN(MOD(X + 90, 360), MOD(X - 90, 360))

B1 =MIN(MOD(X + 90, 360), MOD(X - 90, 360))

THANKS A LOT SIR

A1 =MIN(MOD(X + 90, 360), MOD(X - 90, 360))

B1 =MAX(MOD(X + 90, 360), MOD(X - 90, 360))

 

[Joe4]

gfdwer2,

Please Note: In the future, when marking a post as the solution, please mark the post that originally contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.