Hi Bernie

The .1 is degrees

What is radians?

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

Thanks


"Bernie Deitrick" wrote:

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


"jimE" wrote in message
...
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