Excel ATANH Function

What is the ATANH Function in Excel?

The ATANH function is one of the math functions of Excel.

It Returns the inverse hyperbolic tangent of a number.

We can find this function in Math & trig category of insert function Tab.

How to use ATANH function in excel

  1. Click on an empty cell (like F5 )
an empty cell in excel

2. Click on fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select ATANH function

6. Then select ok

Excel ATANH Function

7. In the function arguments Tab you will see ATANH function

8. Number Is any real number between -1 and 1 excluding -1 and 1

9. You will see results in the formula result section

How to use ATANH function in excel

Examples of ATANH function in Excel

Example 1:

How to use ATANH function in excel

You can see examples of ATANH function below:

Examples of ATANH function in Excel
atanh(-0.5) ----->>>>answer is  -0.549

atanh(-0.2) ----->>>>answer is  -0.202

atanh(0) ----->>>>answer is  0

atanh(0.2) ----->>>>answer is  0.202

atanh(0.5) ----->>>>answer is  0.549

What is the purpose of ATANH function?

It Returns the inverse hyperbolic tangent of a number.

What is the Return value of ATANH function?

It returns a number.

How many arguments does ATANH function have?

This function has just 1 Argument.

The argument of ATANH function is number.

Number Is any real number between -1 and 1 excluding -1 and 1.

The argument of ATANH function is required and not optional.

ATANH(number) = number

Which version of excel supports ATANH function?

This function is available for all excel versions (2003-2019)

Errors in ATANH function

ATANH related functions :

Leave a Reply

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