ACOSH returns the inverse hyperbolic cosine of a number, meaning it finds the value whose hyperbolic cosine equals the given number. It is the reverse of COSH and requires a number greater than or equal to 1.
=ACOSH(number)What does ACOSH do?
The ACOSH function calculates the inverse hyperbolic cosine of a number. In practical terms, if you know a hyperbolic cosine value and need to find the original angle or quantity, ACOSH gives you that answer. Excel's Math & Trig category includes it alongside COSH, SINH, and TANH for hyperbolic calculations.
You might wonder when an office worker or student needs hyperbolic functions. They appear in engineering, physics, statistics, and finance—for example, modelling cable curves, calculating distances in certain geometries, or working with growth and decay formulas. ACOSH is also useful for reversing a COSH calculation when you have the result but need the input.
A common situation: a civil engineer has a table of hyperbolic cosine values for a suspension bridge cable and needs to recover the original parameter values. Instead of manually solving, they use =ACOSH(value) to get accurate results quickly. This guide walks through simple to realistic examples so you can apply ACOSH confidently.
When to use ACOSH
- Reverse a COSH calculation to find the original input value.
- Solve engineering formulas involving catenary curves or hyperbolic geometry.
- Work with statistical distributions that use inverse hyperbolic transformations.
- Convert hyperbolic cosine values back to angles or parameters in physics problems.
- Check or audit calculations where COSH was applied and the source value is needed.
ACOSH syntax
=ACOSH(number)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The hyperbolic cosine value you want to reverse. It must be a number greater than or equal to 1. Example: =ACOSH(1.54308063481524) returns approximately 1. |
What it returns: ACOSH returns a numeric value (the inverse hyperbolic cosine) in radians. The result is always greater than or equal to 0.
ACOSH examples
1 Basic ACOSH calculation
This example shows the simplest use: finding the inverse hyperbolic cosine of a single number. The formula =ACOSH(B2) takes the value in B2 (which is 2) and returns approximately 1.316957897. This is useful when you have a known hyperbolic cosine and need the corresponding angle in radians.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Input | Value | |||
| 2 | Number | 2 | 1.316957897 | ||
| 3 | Note | Must be >= 1 | |||
| 4 |
2 ACOSH for a list of values
Here we apply ACOSH to several values in a column. The formula =ACOSH(B2) is entered in D2 and can be filled down. Each result is the inverse hyperbolic cosine of the corresponding value in column B. This is handy when processing a batch of measurements.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | ID | COSH Value | |||
| 2 | M1 | 1.5 | 0.9624236501 | ||
| 3 | M2 | 2.5 | |||
| 4 | M3 | 3.5 | |||
| 5 | M4 | 4.5 | |||
| 6 |
3 Reverse a COSH calculation
Suppose you previously calculated COSH of some angles and now need the original angles back. The formula =ACOSH(B2) reverses the COSH operation. For B2 = 1.54308063481524 (which is COSH(1)), ACOSH returns 1, confirming the original angle. This is useful for verifying or recovering data.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Angle (rad) | COSH Result | |||
| 2 | 1 | 1.543080635 | 1 | ||
| 3 | 2 | 3.762195691 | |||
| 4 | 3 | 10.067662 | |||
| 5 |
4 Engineering: catenary cable parameter
In a catenary curve, the shape is described by hyperbolic functions. If you have the ratio of tension to weight (a COSH value), ACOSH gives the parameter. The formula =ACOSH(B2) computes the inverse hyperbolic cosine of the ratio in B2. For B2 = 2.5, the result is approximately 1.566799237, which can be used in further cable calculations.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Span (m) | Tension Ratio | |||
| 2 | 10 | 2.5 | 1.566799237 | ||
| 3 | 20 | 3.2 | |||
| 4 | 30 | 4.1 | |||
| 5 |
5 Finance: inverse hyperbolic transformation
Some financial models use hyperbolic transformations to stabilise variance. If you have transformed values and need to invert them, ACOSH helps. The formula =ACOSH(B2) returns the inverse hyperbolic cosine of the transformed value in B2. For B2 = 1.8, the result is approximately 1.192910782, which can be used to recover the original scale.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Asset | Transformed Value | |||
| 2 | Bond A | 1.8 | 1.192910731 | ||
| 3 | Bond B | 2.2 | |||
| 4 | Bond C | 2.9 | |||
| 5 |
Common ACOSH errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #NUM! | The number argument is less than 1, which is outside the domain of ACOSH. | Ensure the input is greater than or equal to 1. If you have values below 1, check your data or use a different function. |
| #VALUE! | The number argument is not numeric (e.g., text or a blank cell). | Verify that the cell contains a number. Convert text to numbers or reference the correct cell. |
| #NAME? | The function name is misspelled (e.g., ACOSHH) or the Analysis ToolPak is not enabled in very old Excel versions. | Check the spelling: =ACOSH(. In modern Excel, the function is built-in. |
| #DIV/0! | ACOSH itself does not cause this, but if combined with division by zero in a larger formula. | Review the entire formula for division operations and ensure denominators are not zero. |
Tips for using ACOSH
- Remember that ACOSH requires a number >= 1; values below 1 will return #NUM!.
- Use ACOSH to reverse COSH calculations when you need the original angle or parameter.
- The result is in radians; convert to degrees with
=DEGREES(ACOSH(number))if needed. - Combine ACOSH with ROUND to control decimal places:
=ROUND(ACOSH(A1),2). - Test with a known value:
=ACOSH(COSH(1))should return 1. - If you get #VALUE!, check for hidden spaces or text in the referenced cell.
Frequently asked questions
What is the difference between ACOSH and COSH?
COSH calculates the hyperbolic cosine of a number, while ACOSH does the reverse: it returns the number whose hyperbolic cosine is the given value. ACOSH is the inverse function.
Why does ACOSH return #NUM!?
ACOSH returns #NUM! when the input number is less than 1, because the inverse hyperbolic cosine is only defined for values >= 1.
Can ACOSH return degrees instead of radians?
ACOSH returns radians. To convert to degrees, wrap it in the DEGREES function: =DEGREES(ACOSH(number)).
Is ACOSH available in all Excel versions?
Yes, ACOSH is available in Excel 2007 and later, and also in Excel for the web, Mac, and mobile. In very old versions, it may require the Analysis ToolPak.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ACOSH reference