Summary

The Excel COSH function returns the hyperbolic cosine of a number.

Purpose 

Get hyperbolic cosine of a number

Return value 

The hyperbolic cosine of the number.

Syntax

=COSH(number)
  • number - The hyperbolic angle.

How to use 

The Excel COSH function returns the hyperbolic cosine of a number, which represents a hyperbolic angle. Given the input of 1, the function returns the value 1.543080635.

=COSH(1) // returns 1.543080635

Explanation

The hyperbolic cosine function returns the horizontal component of the point on the right branch (x ≥ 1) of the unit hyperbola corresponding to the hyperbolic angle given as input. 

The hyperbolic cosine returns the horizontal component of the point on the unit hyperbola.

Together with the hyperbolic sine function, the functions parameterize the right branch of the unit hyperbola given by the equation x² - y² = 1. In plain language, this means that the two functions trace out the shape of the right branch of the unit hyperbola. Given a hyperbolic angle corresponding to a point on the hyperbola's curve, COSH returns the horizontal component of the point, while SINH returns the vertical component of the point.

For example, given the hyperbolic angle -1, hyperbolic cosine returns the x-component 1.543080635, and hyperbolic sine returns the y-component -1.175201194.

Hyperbolic cosine and sine example.

Here is a table that shows some points on the unit hyperbola formed by COSH and SINH.

Hyperbolic cosine and sine table.

As the value of the hyperbolic angle gets larger, the horizontal component diverges to infinity. This is different from the circular cosine function, which is periodic and repeats values.

Hyperbolic cosine plot.

Images courtesy of wumbo.net.

 

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.