Excel ATANH Function
The Excel ATANH function returns inverse hyperbolic tangent of a number. The inverse hyperbolic tangent of x is defined as:
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 in Excel. As a worksheet function, the ATANH function can be used as part of a formula in a worksheet cell.
Syntax
ATANH(number)
Parameters
number |
Required. Specify the value to get the inverse hyperbolic tangent of. The number must be between -1 and 1 exclusive. |
Return Value
Returns the inverse hyperbolic tangent of a value.
Notes
- If the argument is outside of the range from -1 to 1 exclusive, ATANH returns #NUM! error.
- If the argument is a non-numeric value, ATANH returns #VALUE! error.
Example: Using as Worksheet Function
The example below shows how to use the ATANH function as worksheet function.
Based on the Excel spreadsheet above, the output of the following worksheet formula will be:
=ATANH(B5) Result: -1.47221949 =ATANH(B6) Result: -0.549306144 =ATANH(B7) Result: -0.309519604 =ATANH(B8) Result: 0 =ATANH(B9) Result: 0.309519604 =ATANH(B10) Result: 0.549306144 =ATANH(B11) Result: 1.47221949
❮ Excel Functions
