Formualizer Docs
ReferenceFunctionsMath Functions

ACOSH

ACOSH: Returns the inverse hyperbolic cosine of a number.

Summary

ACOSH is the inverse of COSH for inputs at or above 1.

Remarks

  • Domain: input must be greater than or equal to 1.
  • Radians: this function is hyperbolic, so the output is not an angle in radians.
  • Errors: returns #NUM! when the input is less than 1.

Examples

Boundary value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0
Inverse hyperbolic cosine of ten
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2.993222846126381

FAQ

When does ACOSH return #NUM!?

ACOSH requires input >= 1; values below 1 return #NUM!.

Runtime metadata

Category

Math

Signature

ACOSH(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PUREELEMENTWISENUMERIC_ONLY

Source

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

ACOS

ACOS: Returns the angle in radians whose cosine is the input value.

ACOT

ACOT: Returns the angle in radians whose cotangent is the input value.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does ACOSH return #NUM!?Runtime metadata