Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




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




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.
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.worksheet.functions




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




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




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




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




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 'arctan') =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 
Display Modes  


Similar Threads  
Thread  Forum  
Auto Calculate  Excel Discussion (Misc queries)  
can't get excel to calculate  Excel Worksheet Functions  
any formula to auto calculate 1st12th is 12 days pls?  Excel Discussion (Misc queries)  
Spreadsheet Won't Calculate  Excel Discussion (Misc queries)  
How to calculate an inverse of log base 10  Excel Worksheet Functions 