Google スプレッドシート関数

ATANH

Returns the inverse hyperbolic tangent of a number.

この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。

構文

ATANH(number)

The ATANH function calculates the inverse hyperbolic tangent of a given number. The number must be between -1 and 1 (exclusive).

=ATANH(0.5)

結果: 0.549306144

Calculates the inverse hyperbolic tangent of 0.5.

=ATANH(-0.1)

結果: -0.100335348

Calculates the inverse hyperbolic tangent of -0.1.

What happens if the number is outside the range -1 to 1?

The function will return a #NUM! error because the inverse hyperbolic tangent is not defined for those values.