how do i calculate inverse tan?

[emma]

Hi, I have to calculate TAN y angle and I on my scientific calculator i would
do 8.391/14.142 *inv tan and get 30.68 degrees. I cannot seem to find out how
to do this in excel. Please help.

 

[vezerid]

=ATAN(8.391/14.142)*180/PI()

HTH
Kostis Vezerides

 

[emma]

THANK YOU VERY MUCH.

=ATAN(8.391/14.142)*180/PI()

HTH
Kostis Vezerides

 

[vezerid]

You are welcome. Glad it worked.

Kostis

 

[David Biddulph]

.... or
=DEGREES(ATAN(8.391/14.142))

 

[Bernard Liengme]

Excel does trig in radians hence the 180/PI()
To save you remembering which way to do this use the conversion function
So to find the Tan of 60 or of degree value in A1
=TAN(RADIANS(60)) or TAN)RADIANS(A1)
and to find the inverse tan (we oldies you we brought up with log 7 trig
paper tables call that the 'arc-tan')
=DEGREES(ATAN(A2)
best wishes