In Excel, the hyperbolic functions COSH, SINH, and TANH all take a number representing a hyperbolic angle as input. A hyperbolic angle is defined by the area of the sector on the right branch of the unit hyperbola x² - y² = 1, formed by the origin, the point (1,0), and a point on the unit hyperbola. For example, a hyperbolic angle of 1 corresponds to the sector formed on the unit hyperbola with an area of one-half.

The hyperbolic angle of one.

In general, you can think about a hyperbolic angle forming a point on the unit hyperbola, where COSH and SINH give the coordinates of the point:

The point formed by a hyperbolic angle

A negative hyperbolic angle corresponds to a point with a negative y-coordinate.

The point formed by a negative hyperbolic angle

The area of the sector is half the angle's value to align the hyperbolic functions with their circular counterparts: cosine and sine. This is because the area formed by a circular angle on the unit circle is one-half the angle's value.

Area of a circular angle.

Dividing by two makes the area of a hyperbolic angle equal to that of a circular angle. For example, the geometry of the hyperbolic and circular functions for the angle a=1 is shown below.

Hyperbolic vs. circular angle.

Unlike a circular angle, whose point rotates periodically around the circle as the angle grows, a hyperbolic angle diverges toward infinity as it increases positively and toward negative infinity as it increases negatively.

As a hyperbolic angle grows larger the corresponding point diverges towards inifinity.

Images courtesy of wumbo.net.

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass