Check Sheet Logo
Check Sheet


The ATANH function returns the inverse hyperbolic tangent of a value. It is commonly used in mathematical calculations involving hyperbolic functions.


Use the ATANH formula with the syntax shown below, it has 1 required parameter:

  1. value (required):
    The numeric value for which to calculate the inverse hyperbolic tangent. Must be between -1 and 1, inclusive.


Here are a few example use cases that explain how to use the ATANH formula in Google Sheets.

Calculate the angle of a hyperbolic triangle

When working with hyperbolic triangles, ATANH can be used to calculate the angle opposite a given side length.

Calculate the rate of change of a hyperbolic function

ATANH can be used in conjunction with other hyperbolic functions to calculate the rate of change at a given point.

Common Mistakes

ATANH not working? Here are some common mistakes people make when using the ATANH Google Sheets Formula:

Incorrect syntax

Make sure to use the correct syntax for the ATANH formula: ATANH(value). The 'value' parameter is required and should be a number.

Using non-numeric value

The 'value' parameter should be a numeric value. Make sure that you are not using text, empty cells or cells with errors.

Divide by zero error

If you provide a value of 1 or -1 as the 'value' parameter, the formula will result in a divide by zero error. Make sure to avoid these values.

Confusing with other formulas

Be careful not to confuse ATANH with other similar formulas such as TANH or ATAN. Check the syntax carefully to ensure you are using the correct formula.

Not enabling iterative calculation

If you are using ATANH as part of an iterative calculation, make sure to enable iterative calculation in the settings to ensure the formula updates correctly.

The following functions are similar to ATANH or are often used with it in a formula:

  • SINH

    The SINH function returns the hyperbolic sine of any real number. The hyperbolic sine is a mathematical function that describes the shape of a hanging cable supported at its ends and acted upon by a uniform gravitational force. In Google Sheets, it is most commonly used in mathematical and statistical formulas.

  • COSH

    The COSH function returns the hyperbolic cosine of a given value. The hyperbolic cosine is defined as (ex + e-x) / 2, where x is the given value. This function is most commonly used in mathematical calculations and modeling.

  • TANH

    The TANH function returns the hyperbolic tangent of a value. It is commonly used in mathematical modeling, such as in statistics, physics, and engineering.


    The ACOSH function returns the inverse hyperbolic cosine of a number. In other words, it calculates the value whose hyperbolic cosine is the specified number. This function is useful for solving mathematical problems involving hyperbolic functions.


    The ASINH function returns the inverse hyperbolic sine of a number. It is a mathematical function that can be used in a variety of applications such as calculating the surface area of a hyperbolic paraboloid. The result of the function is in radians.

Learn More

You can learn more about the ATANH Google Sheets function on Google Support.