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

ATANH(number)

 
 Returns the inverse hyperbolic tangent of a number.

 numberThe number you want the inverse hyperbolic tangent of.

 REMARKS
 
  		• The inverse hyperbolic tangent of an angle is the inverse of the TANH() function.
     
  		• If "number" > 1, then #NUM! is returned.
     
  		• If "number" < 1, then #NUM! is returned.
     
  		• If "number" = 1, then #NUM! is returned.
     
  		• If "number" is not numeric, then #VALUE! is returned.

     EXAMPLES
     
     A
    1=ATANH(0.5) = 0.549
    2=ATANH(-0.1) = -0.1
    3=ATANH(0.76159416) = 1
    4=ATANH(TANH(0.5)) = 0.5
    5=ATANH(1) = #NUM!
    6=ATANH(-1) = #NUM!
    7=ATANH(-10) = #NUM!
    8=ATANH("some text") = #VALUE!
    		 
     Functions - A | Index - A | Office Online 

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