Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 751
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 751
Default how do i calculate inverse tan?

You are welcome. Glad it worked.

Kostis


emma wrote:
THANK YOU VERY MUCH.




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 618
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Calculate Nick Leach Excel Discussion (Misc queries) 1 September 22nd 06 02:42 AM
can't get excel to calculate jack Excel Worksheet Functions 1 August 29th 06 04:36 AM
any formula to auto calculate 1st-12th is 12 days pls? Kelly Lim Excel Discussion (Misc queries) 13 June 17th 06 09:25 AM
Spreadsheet Won't Calculate Scott Excel Discussion (Misc queries) 0 September 29th 05 05:37 PM
How to calculate an inverse of log base 10 Abdul Basit Excel Worksheet Functions 1 August 6th 05 06:52 AM


All times are GMT +1. The time now is 09:32 AM.

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

About Us

"It's about Microsoft Excel"