Excel trig formula problem.

[prostreet]

Help with an Excel formula.
I'm trying to find the correct formula in Excel to find one angle in a right tringle. Given the hypotenuse of 5. One angle of 36.8699 deg. and of course 90. deg.
I input in a scientific calculator as,
"5 * cos(36.8699).
I receive 3.99999 which is correct.
In Excel i get 3.377285781.
I believe I tried a few things like =degrees(5*cos(36.8699)),
=cell r_c*PI()/180.
Still incorrect .
Any and all help with this simple problem will be appreciated.
Thank you!
Jerome

 

[Shortmeister1]

Have a look at this.

Redirecting

answers.microsoft.com

 

[ReignEternal]

Im not sure if we are allowed to point towards an external YouTube that shows what you are looking for so I apologize to the Admins in advance.

I believe this will help you out.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B
1
2	5	3.999999877
3	36.8699
Main

Cell Formulas
Range	Formula
B2	B2	=A2*COS(RADIANS(A3))

 

[prostreet]

How about

+Fluff 1.xlsm
	A	B
1
2	5	3.999999877
3	36.8699
Main

Cell Formulas
Range	Formula
B2	B2	=A2*COS(RADIANS(A3))

Thank you, Thank you, Thank you.
Worked perfectly.
I appreciate your solution!
Jerome

 

[Fluff]

Glad to help & thanks for the feedback.

 

[offthelip]

The three angles in a triangle always add up to 180 degrees so the third angle in your triange is:
180 -90 -36.8699=53.1301 degrees