Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > ATAN
 

ATAN(number)

 
 Returns the arctangent of a number in radians.

 numberThe number you want the arctangent of.

 REMARKS
 
  		• The arctangent of an angle is the inverse of the TAN() function.
     
  		• The "number" is the angle in radians.
     
  		• If "number" is not numeric, then #VALUE! is returned.
     
  		• The returned angle is given in radians between -PI/2 and PI/2.
     
  		• If your argument is in degrees, multiply it by PI()/180 to convert it to radians.
     
  		• If you want to convert the result from radians to degrees, multiply it by 180/PI( ).
     
  		• You can the DEGREES() function to convert from radians to degrees.

     EXAMPLES
     
     A
    1=ATAN(0) = Ge0eral
    2=ATAN(1) = 0.785
    3=ATAN(-1) = -0.785
    4=ATAN(1)*180/PI() = 45
    5=DEGREES(ATAN(1)) = 45
    6=ATAN(-50) = -1.551
    7=ATAN(TAN(0.5)) = 0.5
    8=ATAN(100) = 1.561
    9=ATAN(3/2)=ATAN2(2,3) = -1.000
    10=ATAN("some text") = #VALUE!
    		 
     Functions - A | Index - A | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top