Returning an angle in degrees from a vector

[bfischlike]

Hello!
This is my first post on this site, BUT I have been viewing and gaining knowledge for quite sometime. Thanks for all everyone does to help.

What I am trying to figure out how to do is return a value (angle in degrees) for a vector that is 90 degrees or less.

For example if my upper limit was 55 with a reciprocal of 235 (180deg off) and my vector was 100, I would have two angle measurements. One at 45deg and (the one I want) and one at 135deg.

I am trying to figure out how to make excel return the lesser value.

I have attached a diagram as a visual of my above scenario.

Thanks for any help!

-Brandon

 

[JGordon11]

angle.xlsx
	A	B	C	D	E	F
1	upper	lower	vector	angle 1	angle 2	small angle
2	55	235	100	45	135	45
3	5	185	355	170	10	10
4	355	175	180	175	5	5
5	450	270	180	90	90	90
6	0	180	0	0	180	0
7	-90	90	5	95	85	85
Sheet1

Cell Formulas
Range	Formula
D2:D7	D2	=MOD(ABS(A2-C2),180)
E2:E7	E2	=180-D2
F2:F7	F2	=MIN(D2:E2)
B2:B7	B2	=MOD(A2+180,360)

 

[mikerickson]

It sounds like you might be looking for ASIN(SIN(A1+B1)) with the appropriate use of RADIANS and DEGREES depening on the units of your input variables.