Formualizer Docs
ReferenceFunctionsMath Functions

ATANH

ATANH: Returns the inverse hyperbolic tangent of a number.

Summary

ATANH is the inverse of TANH on the open interval (-1, 1).

Remarks

  • Domain: input must be strictly between -1 and 1.
  • Radians: this function is hyperbolic, so the output is not an angle in radians.
  • Errors: returns #NUM! when the input is <= -1 or >= 1.

Examples

Inverse hyperbolic tangent of one half
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5493061443340548
Domain boundary error
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#NUM!

FAQ

Which inputs are invalid for ATANH?

ATANH is only defined on (-1, 1); endpoints and outside values return #NUM!.

Runtime metadata

Category

Math

Signature

ATANH(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PUREELEMENTWISENUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/math/trig.rs

ATAN2

ATAN2: Returns the arctangent of `y/x`, preserving quadrant information.

AVERAGE

AVERAGE: Returns the arithmetic mean of numeric values across scalars and ranges.

On this page

SummaryRemarksExamplesRelated functionsFAQWhich inputs are invalid for ATANH?Runtime metadata