ExcelFlux

ATANH function

the inverse hyperbolic tangent of a number.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

The inverse hyperbolic tangent requires a ratio strictly between −1 and 1.

A worked example from the workbook

RowA
6Input
7-0.5
80
90.5
Record 1
=ATANH(A7)

Expected result-0.5493061443

See the inputs and instructions for all 3 examples

Syntax

ATANH(number)

Copyable formulas

English Excel · en-US
=ATANH(0)
Turkish Excel · tr-TR
=ATANH(0)

Expected result

0

Worked examples

The inverse hyperbolic tangent requires a ratio strictly between −1 and 1.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 -0.5
8 0
9 0.5
Case Formula Expected result
Record 1 =ATANH(A7) -0.5493061443
Record 2 =ATANH(A8) 0
Record 3 =ATANH(A9) 0.5493061443
Microsoft Excel reference