Math
ASINH, ACOSH, and ATANH: inverse hyperbolic functions and domain limits
Evaluate inverse hyperbolic sine, cosine, and tangent transformations—including Fisher Z correlation transforms with ATANH.
Domains of ASINH, ACOSH, and ATANH
ASINH(x) accepts any real number, ACOSH(x) requires x >= 1, and ATANH(x) requires -1 < x < 1 (used in Fisher z-transformation of correlation r).
Passing x < 1 to ACOSH or ABS(x) >= 1 to ATANH returns #NUM!.
=ROUND(ATANH(B2), 6)Try the example
Use the original values or change them to test your understanding.