Returns the inverse hyperbolic tangent of a number.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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)Risultato: 0.549306144
Calculates the inverse hyperbolic tangent of 0.5.
=ATANH(-0.1)Risultato: -0.100335348
Calculates the inverse hyperbolic tangent of -0.1.
The function will return a #NUM! error because the inverse hyperbolic tangent is not defined for those values.