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.

Calculating inverse tangent (tan^-1) in Excel

1. Enter the values for your calculation in separate cells.
2. In a third cell, enter the formula "=ATAN(8.391/14.142)" (without the quotes).
3. Press Enter to get the result in radians.

1. To convert radians to degrees, multiply the result by 180/PI or use the DEGREES function.
2. For example, if the result of the ATAN function is in cell C1, you can use the formula "=C1*180/PI()" or "=DEGREES(C1)" to convert the result to degrees.

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

HTH
Kostis Vezerides


emma wrote:
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.

THANK YOU VERY MUCH.

"vezerid" wrote:

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

HTH
Kostis Vezerides


emma wrote:
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.

You are welcome. Glad it worked.

Kostis


emma wrote:
THANK YOU VERY MUCH.

.... or
=DEGREES(ATAN(8.391/14.142))
--
David Biddulph

"vezerid" wrote in message
oups.com...
=ATAN(8.391/14.142)*180/PI()

HTH
Kostis Vezerides

emma wrote:
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.

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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