Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inverse Tangent in excel formulae
How do i use the inverse tangent in an excel formulae? I need to use it to
calculate the distances of a data set. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inverse Tangent in excel formulae
=DEGREES(ATAN(A1)) if you want arctan with one argument.
=DEGREES(ATAN2(A1,B1)) if you want the version with 2 arguments to resolve the ambiguity of quadrants. Obviously you can omit the DEGREES() function if you want your answer in radians. -- David Biddulph "Kirsty" wrote in message ... How do i use the inverse tangent in an excel formulae? I need to use it to calculate the distances of a data set. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Excel : Hiding/Locking Formulae | Excel Discussion (Misc queries) | |||
formulae have stoped working on an excel sheet | Excel Worksheet Functions |