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

TAN(number)

 
 Returns the tangent of an angle in radians.

 numberThe number you want the tangent of.

 REMARKS
 
  		• The "number" is the angle in radians.
     
  		• If "number" is not numeric, then #VALUE! is returned.
     
  		• If your argument is in degrees, multiply it by PI()/180 to convert it to radians.
     
  		• If you want the result to be in degrees, multiply the result by 180/PI().
     
  		• You can use the DEGREES() function to convert from radians to degrees.
     
  		• The inverse of this function is the ATAN() function.

     EXAMPLES
     
     A
    1=TAN(0.5) = 0.546
    2=TAN(60*PI()/180) = 1.732
    3=TAN(-50) = 0.272
    4=TAN(-1) = -1.557
    5=TAN(ATAN(0.5)) = 0.5
    6=TAN("some text") = #VALUE!
    		 
     Functions - T | Index - T | Office Online 

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