ACOSH Function

Excel Functions › Math & Trig

All versions Math & Trig

The Excel ACOSH function returns the inverse hyperbolic cosine of a number — the non-negative value whose hyperbolic cosine (COSH) is the given number. The input must be 1 or greater.


Quick answer:
=ACOSH(1) inverse hyperbolic cosine of 1 = 0

Syntax

=ACOSH(number)
ArgumentDescription
numberRequiredA number greater than or equal to 1. ACOSH returns the non-negative value whose COSH equals that number.

How to use it

ACOSH is the inverse of COSH (the hyperbolic cosine). Its result is a plain number, not an angle. The input must be at least 1, because COSH never produces a value below 1:

=ACOSH(1) // = 0
=ACOSH(10) // approx 2.9932
=ACOSH(COSH(2)) // round-trip = 2

Mathematically ACOSH(x) = LN(x + SQRT(x^2 - 1)). Feeding ACOSH a value below 1 returns #NUM!, since the square root would be of a negative number. The result is always non-negative.

Domain matters: ACOSH only accepts numbers ≥ 1. Values like 0 or 0.5 return #NUM! because COSH never dips below 1.

Try it: interactive demo

Live demo

Pick a ACOSH example to see the formula and its result.

Result:

Practice workbook

📊
Download the free ACOSH practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.

Frequently asked questions

What input range does ACOSH accept?
The argument must be ≥ 1. A value below 1 returns #NUM!, because the hyperbolic cosine never goes below 1.
Why does ACOSH(1) equal 0?
COSH(0) is 1, so the value whose hyperbolic cosine is 1 is 0. Hence =ACOSH(1) returns 0.
Is the ACOSH result an angle?
No. ACOSH is hyperbolic, so the result is a real number, not an angle — do not use DEGREES on it.
How is ACOSH defined?
ACOSH(x) = LN(x + SQRT(x^2 - 1)), valid for x ≥ 1.

Master functions like this in one day

This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related functions: COSH · ASINH · ATANH · ACOS · LN · ACOTH