Remember Me?

#### Menu

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 55
how do i calculate inverse tan?

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.
#2
 Excel Super Guru Posts: 1,867
Answer: how do i calculate inverse tan?

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.
__________________
I am not human. I am an Excel Wizard
#3
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 751
how do i calculate inverse tan?

=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.

#4
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 55
how do i calculate inverse tan?

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.

#5
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 751
how do i calculate inverse tan?

You are welcome. Glad it worked.

Kostis

emma wrote:
THANK YOU VERY MUCH.

#6
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 618
how do i calculate inverse tan?

.... 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.

#7
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 4,393
how do i calculate inverse tan?

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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Nick Leach Excel Discussion (Misc queries) 1 September 22nd 06 02:42 AM jack Excel Worksheet Functions 1 August 29th 06 04:36 AM Kelly Lim Excel Discussion (Misc queries) 13 June 17th 06 09:25 AM Scott Excel Discussion (Misc queries) 0 September 29th 05 05:37 PM Abdul Basit Excel Worksheet Functions 1 August 6th 05 06:52 AM

All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"