View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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.