Summary

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

Purpose 

Get inverse hyperbolic tangent of number

Return value 

The inverse hyperbolic tangent.

Syntax

=ATANH(number)
  • number - The number to get the inverse hyperbolic tangent of.

How to use 

The Excel ATANH function returns the inverse hyperbolic tangent of a number. Given 0.5 as input, the function returns 0.549306144 as output.

=ATANH(0.5) // returns 0.549306144

Explanation

The hyperbolic arc tangent function is the inverse of the TANH function.

=ATANH(TANH(x)) // returns x

The plot below shows the output of the ATANH function in Excel.

Plot of hyperbolic arc tangent.

Notes:

  • Given output greater than or equal to 1.0 or less than or equal to -1.0, throws a #NUM error.

 

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.