ACOTH Function

Excel 2007+

Summary

The Excel ACOTH function calculates the inverse hyperbolic cotangent (hyperbolic arccotangent) of a number. This trigonometric function is essential for advanced mathematical calculations involving hyperbolic geometry and engineering applications.

Syntax

ACOTH(number)

Parameters

Parameter Type Required Description
number Number Yes Required numeric input. The absolute value of this number must be greater than or equal to 1. Values with absolute value less than 1 will generate errors.

Using the ACOTH Function

ACOTH is used in advanced mathematical modeling, physics simulations, and engineering calculations where hyperbolic functions are required. It serves as the inverse operation to the COTH function, converting a hyperbolic cotangent value back to its original angle measure.

Common ACOTH Examples

Basic ACOTH Calculation

=ACOTH(6)

Returns approximately 0.168, which is the inverse hyperbolic cotangent of 6.

Real-world Application

=ACOTH(2.5)

Calculates the hyperbolic angle whose cotangent is 2.5, useful in transmission line analysis.

Frequently Asked Questions

ACOTH returns a #NUM! error if the absolute value of the number is less than or equal to 1.

ACOTH is available in Excel 2007 and all later versions including Excel 2010, 2013, 2016, 2019, 2021, and Microsoft 365.

Common Errors and Solutions

#NUM! Error

Cause: The absolute value of the input number is less than or equal to 1

Solution: Use a number where ABS(number) > 1

#VALUE! Error

Cause: Non-numeric input provided

Solution: Ensure the input is a valid number

Notes

  • ACOTH is the inverse of the COTH function
  • Hyperbolic functions grow exponentially unlike circular trigonometric functions
  • Useful in electrical engineering for transmission line calculations
  • The result is always a real number for valid inputs

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier versions

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+