need formula for finding opposite (trigo)

J

jimE

Hi all

want to use excel to find opposite.
Have ADJ down left
Have angle along top

Table is as follows.

(B2) (c2)
Angle .1 .2 .3 .4 ..........2.5
ADJ
500mm(A3)
..
..
..
..
..
..
3500mm

What formula do i need to use to get the size of the opposite?

Hope you can help

Jim THanks
 
B

Bernie Deitrick

Jim,

In B3, enter

=TAN(B$2)*$A3

and copy to create your block of formulas.

I'm assuming that the .1 is Radians, not degrees

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

Jim,

In B3, enter

=TAN(B$2)*$A3

and copy to create your block of formulas.

I'm assuming that the .1 is Radians, not degrees

HTH,
Bernie
MS Excel MVP
 
J

jimE

Hi Bernie

The .1 is degrees

What is radians?

I not good at maths
if it is degrees does this formula still work?

Thanks
 
B

Bernie Deitrick

Radians is a measure of degrees, where there are PI radians per 180 degrees.
Think of it this way: if you take the radius of a circle, and use some
multiple of that radius to create a line along the circumference of the
circle, the angle that you get (if you extend lines back to the center of
the circle from the two end points) in radians is given by the number of
radii you used. So, it takes 3.1415... radii to cover half of the
circumference of a circle.

But, you just need to convert the degrees to radians, since all Trig
functions in Excel use Radians as the default.

So, use this in cell B3, and copy....

=TAN(RADIANS(B$2))*$A3

HTH,
Bernie
MS Excel MVP
 
Top