How to use the Excel ATANH function

The Microsoft Excel ATANH function returns the inverse hyperbolic tangent of a number. The ATANH function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ATANH function can be entered as part of a formula in a cell of a worksheet.

Syntax: =ATANH(number)

The ATANH function syntax has the following arguments:

  • number: The number you want the inverse hyperbolic tangent of.

Example: Let’s look at some Excel ATANH function examples and explore how to use the ATANH function as a worksheet function in Microsoft Excel:

Syntax:  =ATANH(G36)


Based on the Excel spreadsheet above, the following ATANH examples would return:

Syntax: =ATANH(G37)
Result: -0.775298706

Syntax: =ATANH(G38)
Result: -0.549306144

Syntax: =ATANH(G39)
Result: 0

Syntax: =ATANH(G40)
Result: 0.549306144

Syntax: =ATANH(G41)
Result: 0.775298706

Syntax: =ATANH(G42)
Result: #NUM!

Add a Comment

Your email address will not be published. Required fields are marked *