Home  |  About  | Last |  Submit  |  Contact
AllQuests.com



Previous Question:  error 1004 Method Range of Object_Global failed  Microsoft AccessNext Question:  Lookup troublues  Excel Questions
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.557407725

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

Previous Question:  error 1004 Method Range of Object_Global failed  MrExcel Message Board  Microsoft AccessNext Question:  Lookup troublues  MrExcel Message Board  Excel Questions

- 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