tan, cos etc

anon125

Active Member
Joined
Feb 14, 2008
Messages
371
I know the opposite and adjacent of a right angled triangle.
how do i find the angle in ver 2002 - in degrees!
thanks
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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

Well-known Member
Joined
Apr 22, 2009
Messages
624
Try:

=DEGREES(ATAN(your_tan_value))

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

anon125

Active Member
Joined
Feb 14, 2008
Messages
371
Thanks
but how do i do the initial calc to get the angle using tan and excel!
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115

ADVERTISEMENT

My post #2 explained how to do that.
 

anon125

Active Member
Joined
Feb 14, 2008
Messages
371
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

Active Member
Joined
Feb 14, 2008
Messages
371

ADVERTISEMENT

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

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Yes, something is indeed amiss, because 1/1 is not 1.5574..... :)

Otherwise, you're exactly right.
 

Taul

Well-known Member
Joined
Oct 24, 2004
Messages
748
Office Version
  1. 2019
  2. 2013
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,207
Messages
5,594,840
Members
413,944
Latest member
3xc3ln00b

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top