ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Inverse Tangent in excel formulae (https://www.excelbanter.com/excel-worksheet-functions/128508-inverse-tangent-excel-formulae.html)

Kirsty

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.

David Biddulph

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.





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com