Home  |  About  | Last |  Submit  |  Contact

 Tweet

 Question tan cos etc ( MrExcel Message Board Excel Questions )Updated: 2010-08-17 11:00:29 (12)
 tan cos etc I know the opposite and adjacent of a right angled triangle. how do i find the angle in ver 2002 - in degrees! thanks
 Answers: tan cos etc ( MrExcel Message Board Excel Questions )
 tan cos etc 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. Gerald Higgins
 tan cos etc Try: =DEGREES(ATAN(your_tan_value)) ATAN will return the result in radians. the DEGREES formula will convert from radians to degrees. delaneyjm
 tan cos etc Thanks but how do i do the initial calc to get the angle using tan and excel! anon125
 tan cos etc My post #2 explained how to do that. Gerald Higgins
tan cos etc

Quote:
 Originally Posted by Gerald Higgins 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.
 Tangent Function: tan(θ) = Opposite / Adjacent

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

anon125

tan cos etc

I tried tan(1) which is i think a 45 degree as both sides are 1
 1.55741

then i tried =DEGREES(ATAN(C6))
 and got 57.29577951

something is amiss here!
thanks

anon125

 tan cos etc Yes, something is indeed amiss, because 1/1 is not 1.5574..... Otherwise, you're exactly right. Gerald Higgins
tan cos etc

Quote:
 Originally Posted by Gerald Higgins 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!

anon125

 tan cos etc 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 Paul-H
 tan cos etc anon125 - you're getting confused about how to calculate the TANGENT. As you say, the tangent is given by the opposite / adjacent. And for 45 degrees, this is 1/1. So the tangent IS 1. You don't need to work out the tangent OF 1. Gerald Higgins
 tan cos etc if i got it right you need the angle in degrees: =ATAN(opposite/adjacent)*180/PI() remember the maths bobsan42
tan cos etc

Quote:
 Originally Posted by bobsan42 if i got it right you need the angle in degrees: =ATAN(opposite/adjacent)*180/PI() remember the maths
Yes, you're right, that was covered in previous posts by using Excel's DEGREES function, but your suggestion does the same.

Gerald Higgins

 - Source: tan cos etc MrExcel Message Board Excel Questions- Previous Question: error 1004 Method Range of Object_Global failed MrExcel Message Board Microsoft Access- Next Question: Lookup troublues MrExcel Message Board Excel Questions