ACOTH returns the inverse hyperbolic cotangent of a number, which is the value whose hyperbolic cotangent equals the given number. It is useful in advanced mathematics, engineering, and statistical calculations.
=ACOTH(number)What does ACOTH do?
The ACOTH function in Excel calculates the inverse hyperbolic cotangent of a number. In simple terms, if you know the hyperbolic cotangent of an angle and want to find the original angle, ACOTH gives you that angle. It is part of Excel's Math & Trigonometry functions and is available in Excel 2013 and later.
While hyperbolic functions may sound academic, they appear in real-world modelling: calculating distances in special relativity, solving certain differential equations, and even in financial models involving continuous growth. For office workers and students, ACOTH is a tool to handle these calculations quickly without manual tables.
A common situation is when you have a set of ratios from a model and need to convert them back to the underlying parameter. ACOTH does this in one step, reducing errors and saving time.
When to use ACOTH
- Converting a hyperbolic cotangent value back to its original angle or parameter.
- Solving equations in physics or engineering that involve hyperbolic cotangent.
- Analysing data from experiments where the inverse hyperbolic cotangent is needed.
- Teaching or learning advanced mathematics in Excel.
- Checking results of manual calculations involving hyperbolic functions.
ACOTH syntax
=ACOTH(number)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The hyperbolic cotangent of the angle you want to find. Must be a real number with absolute value greater than 1. For example, 2 or -1.5. |
What it returns: The inverse hyperbolic cotangent of the number, in radians. The result is a real number. If the number is between -1 and 1 inclusive, ACOTH returns #NUM!.
ACOTH examples
1 Basic ACOTH calculation
This example shows the simplest use of ACOTH with a single value. The formula =ACOTH(B2) takes the number in cell B2 (which is 2) and returns its inverse hyperbolic cotangent. The result is approximately 0.5493 radians. This helps you verify the function's behaviour with a known input.
| A | B | C | |
|---|---|---|---|
| 1 | Value | ACOTH Result | |
| 2 | 2 | 0.5493061443 | |
| 3 |
2 ACOTH with negative number
Here we calculate ACOTH for a negative value. The formula =ACOTH(A2) uses the number in A2 (-3) and returns approximately -0.3466 radians. This demonstrates that ACOTH works for negative numbers less than -1. It is useful when dealing with negative parameters in models.
| A | B | C | |
|---|---|---|---|
| 1 | Value | ACOTH Result | |
| 2 | -3 | -0.3465735903 | |
| 3 |
3 ACOTH for multiple values in a table
This example applies ACOTH to a column of values. The formula =ACOTH(B2) is entered in C2 and can be filled down. It converts each hyperbolic cotangent value in column B to its corresponding angle in radians. The first result (for 1.5) is approximately 0.8047 radians. This is efficient for batch processing.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ID | Value | ACOTH | |
| 2 | 1 | 1.5 | 0.8047189562 | |
| 3 | 2 | 2.5 | ||
| 4 | 3 | 3.5 | ||
| 5 |
4 Using ACOTH in a physics context
Suppose you have rapidity values from a relativity problem and need to find the original velocity parameter. The formula =ACOTH(B2) computes the inverse hyperbolic cotangent of the rapidity ratio. For a value of 4, the result is about 0.2554 radians. This shows how ACOTH can be part of scientific calculations.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Particle | Rapidity Ratio | Angle (rad) | |
| 2 | Electron | 4 | 0.2554128119 | |
| 3 | Proton | 5 | ||
| 4 |
5 ACOTH in financial modelling
In some continuous growth models, parameters are expressed as hyperbolic cotangents. Here, the formula =ACOTH(B2) converts the model parameter back to its base rate. For a parameter of 10, the result is approximately 0.1003 radians. This helps analysts interpret model outputs in familiar units.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Scenario | Parameter | Base Rate | |
| 2 | Base | 10 | 0.1003353477 | |
| 3 | Optimistic | 15 | ||
| 4 | Pessimistic | 20 | ||
| 5 |
Common ACOTH errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #NUM! | The number argument is between -1 and 1 inclusive, or is not a real number. | Ensure the number is less than -1 or greater than 1. Check the input value. |
| #VALUE! | The argument is non-numeric, such as text or a blank cell. | Provide a numeric value. If referencing a cell, make sure it contains a number. |
| #NAME? | The function name is misspelled or not available in your Excel version. | Check spelling: ACOTH. Ensure you are using Excel 2013 or later. |
Tips for using ACOTH
- Remember that ACOTH requires the absolute value of the number to be greater than 1.
- Use ACOTH to convert hyperbolic cotangent values back to angles in radians.
- Combine ACOTH with DEGREES to convert the result to degrees if needed.
- For values close to 1 or -1, ACOTH returns very large numbers; handle with care.
- Use cell references instead of hard-coded numbers to make formulas dynamic.
Frequently asked questions
What is the difference between ACOT and ACOTH?
ACOT calculates the inverse cotangent (trigonometric), while ACOTH calculates the inverse hyperbolic cotangent. They are different functions with different domains.
Why does ACOTH return #NUM! for some numbers?
ACOTH is undefined for numbers between -1 and 1 inclusive. Ensure your input is less than -1 or greater than 1.
Can ACOTH return results in degrees?
ACOTH returns radians. To convert to degrees, wrap the formula with the DEGREES function, e.g., =DEGREES(ACOTH(2)).
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ACOTH reference