Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
|
|||
|
|||
![]()
=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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
You are welcome. Glad it worked.
Kostis emma wrote: THANK YOU VERY MUCH. |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
.... 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
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Calculate | Excel Discussion (Misc queries) | |||
can't get excel to calculate | Excel Worksheet Functions | |||
any formula to auto calculate 1st-12th 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 |