ExcelFunctions.net Logo

The Excel ATANH Function

Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Atanh-Function
Search this site:
Custom Search
Inverse Hyperbolic Tangent
The atanh function returns the inverse hyperbolic tangent. Therefore,
ATANH( TANH( z ) ) = z
The equation used to calculate the inverse hyperbolic tangent is:
Inverse Hyperbolic Tangent Equation
Further information on the inverse hyperbolic functions can be found on Wikipedia

Basic Description

The Excel ATANH function calculates the inverse hyperbolic tangent of a supplied number.

The format of the function is :

ATANH( number )

Where the number argument is a real number, between (but not equal to) -1 and 1, which you want to calculate the inverse hyperbolic tangent of.

The number argument can be input to the function either :

-directly
-as a value returned from another function or formula, or
-as a reference to a cell containing a value

Examples

Column B of the spreadsheet below, shows examples of the Excel Atanh Function, used to calculate the inverse hyperbolic tangent of three different values.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
Examples of use of the Excel Atanh Function
 Results:
Excel Atanh Function Results

Further information and examples of the Excel Atanh function can be found on the Microsoft Office website.


Trouble Shooting

If you get an error from the Excel Atanh Function, this is likely to be one of the following:

Common Errors
#NUM! - Occurs if the supplied number argument is ≤ -1 or ≥ 1
#VALUE! - Occurs if the supplied number argument is nonnumeric





Valid XHTML 1.0 Transitional

Disclaimer Privacy Policy

Copyright © 2008-2011 ExcelFunctions.net