tan, cos etc

[anon125]

I know the opposite and adjacent of a right angled triangle.
how do i find the angle in ver 2002 - in degrees!
thanks

 

[Gerald Higgins]

From memory, I think that if you know the opposite and adjacent, then you can calculate the tan = opp/adj.

Then Excel's ATAN function will give you the angle in radians.
You'll need to convert the result to degrees.

Excel help on the trigonometry functions explains how to convert radians to degrees.

 

[delaneyjm]

Try:

=DEGREES(ATAN(your_tan_value))

ATAN will return the result in radians. the DEGREES formula will convert from radians to degrees.

 

[anon125]

Thanks
but how do i do the initial calc to get the angle using tan and excel!

 

[Gerald Higgins]

My post #2 explained how to do that.

 

[anon125]

My post #2 explained how to do that.

#2?
Say the opposite is 1 foot and the adjacent is 20 feet.
so i have 1/20.

<TABLE border=0 cellPadding=5 width=500 align=center><TBODY><TR><TD width=152>Tangent Function:

</TD><TD width=322>tan(θ) = Opposite / Adjacent</TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=5 width=500 align=center><TBODY><TR><TD width=152></TD><TD width=322></TD></TR></TBODY></TABLE>or .05​

do i use tan(.05)? then convert the answer to degrees?
thanks

 

[anon125]

I tried tan(1) which is i think a 45 degree as both sides are 1
<TABLE style="WIDTH: 164pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=219 x:str><COLGROUP><COL style="WIDTH: 164pt; mso-width-source: userset; mso-width-alt: 8009" width=219><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 164pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" id=td_post_2409027 class=xl22 height=17 width=219 align=right x:fmla="=+TAN(1)" x:num="1.5574077246549023">1.557407725</TD></TR></TBODY></TABLE>
then i tried =DEGREES(ATAN(C6))<TABLE style="WIDTH: 164pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=219 x:str><COLGROUP><COL style="WIDTH: 164pt; mso-width-source: userset; mso-width-alt: 8009" width=219><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 164pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 height=17 width=219 align=right x:num="57.295779513082323">and got 57.29577951

</TD></TR></TBODY></TABLE>
something is amiss here!
thanks

 

[Gerald Higgins]

Yes, something is indeed amiss, because 1/1 is not 1.5574.....

Otherwise, you're exactly right.

 

[anon125]

Yes, something is indeed amiss, because 1/1 is not 1.5574.....

Otherwise, you're exactly right.

=tan(1) gave the 1.5574.....
now if you are clever enuf to solve the problem... please do!

 

[Taul]

in cell A1 put the value of 1 (opposite)
in cell B1 put the value of 20 (Adjacent)
in cell C1 put the formula =DEGREES(ATAN(A1/B1)) as shown in one of the previous posts

that should give the result of 2.862 degrees

test it with the value of 1 in cells A1 & B1 and the result should be 45 degrees